List Possible values related to user

[zagzebski]

I have field USER that it associated with specific DEPARTMENTS. The USER field = OSUser()

Is there any way to list the departments in a text box horizontally that related to the USER

The text box would look like:    Departments :  IT, Sales, Facilities

...where IT Sales and Facilities are the values in the DEPARTMENT field that relate to the USER (which is the current OSUser)

Something like.... USER=OSUser()=P(DEPARTMENTS)  ?

Thanks in Advance.

[Anonymous · Accepted solution]

Hi,

Try below,

=Concat(DISTINCT If(USER=OSUser(), DEPARTMENT), ',')

[zagzebski]

Awesome! Thank you,