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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
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