Forum Discussion

Qrew Cadet

3 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

Qrew Cadet

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

Qrew Legend

3 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
------------------------------