BLANK() should return true ONLY for the actual "blank" situation

Topic Labels: Formulas
705 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Currently, BLANK() function returns true even for the cell where the value is 0 (zero). It will be more useful if the BLANK() function returned true strictly if the cell is empty.

1 Reply 1

I prefer to avoid BLANK() entirely. It’s easy enough to check for an empty field by just using the field reference:

IF({Field Name}, ...

Except for fields containing numeric values, that will return true for any non-empty field, and false for any empty field. For numeric fields, use this:

IF({Field Name} & "", ...

That will convert the field contents to a string, where a non-empty string is equivalent to true, and an empty string equates to false.