Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Error in cells where date is missing in formula

Topic Labels: Formulas
242 5
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there,

I know this question has been asked previously, and I realise there’s resources to give an idea, I’m just new to Airtable formulas, and still can’t make it work for me.

My question is super simple. I have a ‘date’ column, and then a column with formula to add 30 days. It then produces an error in all of the cells where the ‘date’ column hasn’t been populated. I realise I need to use ‘IF’… but struggle from there. I’ve tested out examples that I’ve seen, but no luck.

Thank you!

5 Replies 5

You can do something like,

IF(date=blank(),“”,[your +30 formula])

e.g.

IF(
  date=BLANK(),
  "",
  DATETIME_FORMAT(
    DATEADD(
    date,
    30,
    'day'
  ),
  'MM-DD-YYYY'
  )
)

Your formula could be simpler.

IF(
    {date},
    DATEADD( {date}, 30, 'days')
)

Good point. I had to use BLANK() for something that wouldn’t work like that, and it’s just became a default of mine. But when I did the DATEADD without formatting, it did not keep the {date} formatting.

If you use DATEADD() by itself, you get a date object. If the only thing the formula returns is a date object, then you set formatting in the formula formatting options. If you want to combine the date with other text, or if the formula could return text, that’s when you use DATETIME_FORMAT().