Skip to main content
Question

Using 'not ifnull' formula in a 'formula text field'

  • August 9, 2017
  • 0 replies
  • 1061 views
I need some help with a formula. I am trying display text if a field is not null. This is my current formula:

If(not IsNull([AP Supplier Type]), "Oracle Hold",
If(not IsNull([CURRENTWORKNODE]), "Rapid Hold",
If(not IsNull([Amt]), "Payment Hold")))

Currently, everything is being listed as an "Oracle Hold". I am not sure what I am doing wrong. Your help is much appreciated!!
    This topic has been closed for replies.

    The IsNull function is documented not to work with Text Realty. To test of a text field is blank then use the syntax here

    If(Trim([my text field])="", This field is blank")

    Ie you have to test against = empty quotes.
    Terms & ConditionsAccessibility statement