Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Topic Labels: Formulas
264 1
Showing results for 
Search instead for 
Did you mean: 

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.