Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
1038 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Yasutaka_Ito
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.