Help

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

Solved
Jump to Solution
1680 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Liam_Esteban
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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().

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

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().

Liam_Esteban
4 - Data Explorer
4 - Data Explorer

Thank you so much for your quick reply.