How I get particular user from users field in formula field?

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

Hi Team,

I have users field by using that field I want to change the flag of other field.

For Example below is the list of users 

1. abc

2.def

3. ghi 

out of above three users I want that when "abc" user is in the user field then my formula field changes to value '1' else change to '0'

If([user]=ToUser("abc"),1,0)

Can you please help me in correcting above formula.

Photo of Rishab

Rishab

  • 0 Points

Posted 4 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
What is the field type for that field? ie what field type is abc?
Photo of Rishab

Rishab

  • 0 Points
abc is value in USER field and field in which we want to change the flag is formula numeric.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
Try

If([user]=ToUser("jsmith@mycompany.com"),1,0)
Photo of Harrison Hersch (MCF)

Harrison Hersch (MCF), Champion

  • 40 Points
What Mark suggested should resolve the immediate concern. Would you mind sharing your business case though as there may be some more scalable ways to approach what you are doing?