How do I print something when the formula fails? (Excel IFERROR)

[Liam_Esteban]

Excel has the IFERROR function to elegantly catch when a formula fails. Airtable doesn’t seem to have an equivalent. Is there a way to emulate this functionality?

I have an airtable with a list of books that I’m reading. They have a start date and an end date, but I don’t write the end date until I’ve finished the book. I group books by end date and would like the group to be named “Currently reading” instead “#ERROR!”.

Thank you

[Kamille_Parks · Accepted solution]

Use an IF() statement to check if there is a value for the end date.

IF({End Date}, ~something~, "currently reading")

–
Also there is the function ISERROR() which will allow you to test if something returns an error or not when used with IF(). Similarly, there’s ERROR().

Airtable Support

Formula field reference

Formulas may involve functions, numeric operations, logical operations, and text operations that operate on fields. For an overview of formula fields, please refer to the Guide to Formula, Lookup, ...

[Liam_Esteban]

Thank you so much for your quick reply.