Kuovonne's Guide to Airtable

Share

Explore

Kuovonne's Guide to Airtable

Writing Formulas

Testing for Blank Values
Testing for Blank Values

⁠

⁠ Tip Jar ⁠ Thank Kuovonne for creating this content! ⁠ ⁠ ⁠

⁠

⁠

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')

)

⁠

⁠

⁠

⁠

⁠ ⁠ Thank Kuovonne for creating this content! ⁠ Give Kuovonne a sandwich ⁠ Signup for Coda w/ referral link ⁠ ⁠ ⁠Buy from my Gumroad Store ⁠ ⁠ ⁠ ⁠ ⁠

⁠

⁠

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.