Is it possible to write a formula that will look at each user to see if the current user is in any of those fields?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Example:  I have Engineering Manager #1, Engineering Manager #2 and Engineering Manager #3.  I would like to write a formula that captures if the current user is in any of those 3 fields.  In another application, I would like to create a report link that would look back at the formula.  The formula will be the chosen field to look at for exact match in the report link. 

Photo of Daniel

Daniel

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
I will answer your first question.  I don't understand your second question.

IF(
[Engineering Manager #1] = User()
OR
Engineering Manager #2]= User()
OR
Engineering Manager #3]= User(), true)
Photo of Daniel

Daniel

  • 0 Points
Mark, thanks.  This solution is working for me.