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...