Combine User Fields for Reports
I want to see if it is possible to combine three user fields into one for reports. So I want to run a report for user A and user A maybe in field 1, field 2 or field 3. So when I run the report I wa...
Forum Discussion
np
You can make a formula like this as a formula List - User list user field type
ToUserList([user],[Last Modified By])
then you should be able to filer the report on where that field includes the current user.
to get the Current User you can either make a field called [Current User] with a formula of
User()
or else use the legacy and probably undocumented notation of
_curuser_
with leading and trailing underscores.
You can make a formula like this as a formula List - User list user field type
ToUserList([user],[Last Modified By])
then you should be able to filer the report on where that field includes the current user.
to get the Current User you can either make a field called [Current User] with a formula of
User()
or else use the legacy and probably undocumented notation of
_curuser_
with leading and trailing underscores.