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
Best answer by Kamille_Parks11
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().
+27Use 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().
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.