Help

Blank Cell Result rather than #ERROR

Topic Labels: Formulas
Solved
Jump to Solution
2243 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Karen_Piotrowsk
5 - Automation Enthusiast
5 - Automation Enthusiast

As you can tell by my question, I am new to Airtable :slightly_smiling_face:

How do I rewrite this formula so it does not result in …#ERROR when I don’t have dates in some the cells used in the calculation? I would rather have that cell remain blank until I have all my dates entered into my table. Thank you!

DATEADD({Speaking Date},-1,‘days’)

1 Solution

Accepted Solutions
M_k
11 - Venus
11 - Venus

Hi @Karen_Piotrowski

I noticed that the quotes used in the formula that you have in your post, are not the straight ones. You may want to check that you are using the correct quotes.

The formula that @kuovonne used are the correct ones.

Just thought I would help. Hope you don’t mind.

Mary Kay

See Solution in Thread

3 Replies 3

Welcome to the Airtable community,

To avoid the dreaded #ERROR, wrap your formula in an IF that checks for values in the input fields.

IF({Speaking Date},
  DATEADD({Speaking Date},-1,'days')
)
M_k
11 - Venus
11 - Venus

Hi @Karen_Piotrowski

I noticed that the quotes used in the formula that you have in your post, are not the straight ones. You may want to check that you are using the correct quotes.

The formula that @kuovonne used are the correct ones.

Just thought I would help. Hope you don’t mind.

Mary Kay

Thank you so much!!!