Gallery
Kuovonne's Guide to Airtable
Share
Explore
Kuovonne's Guide to Airtable
Writing Formulas

Testing for Blank Values

Thank Kuovonne for creating this content!
info
Avoiding comparisons with BLANK(), and FALSE()
For most field types, you can check if a cell has a value with an IF function.
IF(
{Date},
DATETIME_FORMAT({Date}, "MMMM D, YYYY h:mm A"
)

Notice that you can simply use the field name without comparing the field value to BLANK() or an empty string "".
However, if the field is a number field, and zero is a valid value, you need a different technique. Comparing the number to BLANK() won’t work because Airtable thinks that BLANK() is the same as 0. Instead, you can turn the field into a text string to see if there is a value.
IF(
{Number} & "",
"✔️"
)

If you want to see if a set of fields all have values, use the AND() function.
IF(
AND(
{Date},
{Number} & ""
),
DATEADD({Date}, {Number}, 'days')
)

image.png
Thank Kuovonne for creating this content!

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.