Forum Discussion

AnnettaColeman's avatar
AnnettaColeman
Qrew Cadet
4 years ago

How to write an IF Statement to look for NOT null

In our app we converted 400 projects that had historical SPONSORS as a text field.  Approximately half of the projects are closed so we plan to keep a Sponsor-Historical (text field) for closed p...
Formulas and functions
AnnettaColeman's avatar
AnnettaColeman
Qrew Cadet
4 years ago
Well Duh....   It works just fine if I use <> Null instead of IsNull = False.    Amazing what clarity can be discovered via a Power Nap.  Sorry to waste community time.

------------------------------
Annetta Coleman
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    I just a tip. You can't use IsNull to test for a Text field type being blank. I use this

    IF(Trim([My Text field]) = "", ............)

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
  • MikeTamoush's avatar
    MikeTamoush
    Qrew Elite
    4 years ago
    To add on to Mark's tip:

    If you ARE testing a numerical field simply use:

    isnull([Field]) to test if blank
    not isnull([Field]) to test if not blank (versus isnull <>null....)

    ------------------------------
    Mike Tamoush
    ------------------------------