Skip to main content
Question

If statement using numeric formula fields.

  • June 22, 2020
  • 0 replies
  • 50 views
I am trying to create a Text Formula field that will pull information from three different numeric formula fields. If 1st one is not equal to null, pull the information from 1st field, if the 2nd one is not equal to null, pull the information from 2nd field, if 3rd one is not equal to null, pull information from the 3rd field.  I keep getting an error message "Expecting text but found number".  Is there a way to do an If statement using numeric formula fields?

------------------------------
Nicole Varner
------------------------------
This topic has been closed for replies.

  • PaulPeterson1
  • Quickbase Alumni
  • June 23, 2020
Try something like this:

If(not IsNull([Field 1]), [Field 1], not IsNull([Field 2]), [Field 2], not IsNull([Field 3]), [Field 3])

------------------------------
Paul Peterson
------------------------------
Terms & ConditionsAccessibility statement