I need help with an If statement using a lookup value from a relationship table and the look value is a user

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

I tried the formulas below and I get an error, both fields are Users

If(  not(IsNull([BB_ENGR_OVERRIDE])), [BB_ENGR_OVERRIDE],[SITE_EXCH_ST - BB_ENGINEER])


If([BB_ENGR_OVERRIDE]="", [BB_ENGR_OVERRIDE],[SITE_EXCH_ST - BB_ENGINEER])

Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Can you rtry this and if there is an error post what the error message is?  Also please check that the field type is formula-User



If(not IsNull([BB_ENGR_OVERRIDE]), [BB_ENGR_OVERRIDE],[SITE_EXCH_ST - BB_ENGINEER])
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
Thanks, I needed to change the field type to user formula and it worked perfectly