If formula on a field in a relation table not working.

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

I have a field on the main table that is a lookup field.  I tried to add a formula text field with this formula.

 If (IsNull([Target Region]),"Non-Target","Target")

It only brings back Target regardless.


Photo of cowannbell

cowannbell

  • 680 Points 500 badge 2x thumb

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Yep, the IsNull is documented not to work on text fields,. Not intuitive, I know and many before you have fallen in that same pothole.  So you need to compare it to empty quotes.  I like to Trim it just in case it has some invisible spaces in the data

If (Trim([Target Region])="","Non-Target","Target")
Photo of cowannbell

cowannbell

  • 680 Points 500 badge 2x thumb
Thank you so much, that worked perfectly.  I'll try and remember this in the future.