Formula to select user in multiple fields
I have three user fields in my database. Assigned to, transferred to or reassigned to. In a report I would like to present the user with only one selection for user and it would pull records for tha...
Forum Discussion
Created a new formula user field.
Filter your report to show records where the user in this new field is the current user.
if ( [Assigned to]=User() OR =User() OR [reassigned to]=User() ,User() ,null )
Filter your report to show records where the user in this new field is the current user.