Kuovonne's Guide to Airtable
Share
Explore
Kuovonne's Guide to Airtable
Troubleshooting Formulas

icon picker
Hiding or showing #ERROR!

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

Suppressing #ERROR!

If you want a cell to be blank instead of showing #ERROR!, nest your formula inside an IF() that checks for the error conditions and only proceeds if there are no errors.
For example, division by zero is not allowed, so check if your denominator has a value before performing division.
IF(
{num items},
{sum} / {num items}
)
For example, math with dates requires a date value (not blank), so check if your date field has a value before performing calculations with it.
IF(
{date},
DATEADD({date}, 5, 'days')
)

Showing #ERROR!

Sometimes you want the result of a formula to be an error.
Have the formula return ERROR(). If the formula returns a text string, you can include a description of the error in the function ERROR("This is what is wrong."). However, do not do this for formulas that should return a number or a date.
Use invalid math to create an error: (5 / “Name of error”). The formula result will show as an error, and you can refer to the formula code itself to better understand what happened.
⁠
⁠
⁠
Thank Kuovonne for creating this content!
⁠
Give Kuovonne a sandwich
⁠
Signup for Coda w/ referral link
⁠
⁠
⁠
Buy from my Gumroad Store
⁠
⁠
⁠
⁠
⁠
⁠
⁠
Gallery
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.