Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Adding IF to DATEADD Formula

Topic Labels: Formulas
Solved
Jump to Solution
498 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,
So I have my formula calculating the 90-day deadline from the start date. DATEADD({Start},90,‘day’)

But I want it to only calculate IF there is a date in the start column. Currently, if there is no date in the start column it produces a #error, however, ideally I’d like to set the formula so that the deadline is blank until the actual start date has been entered.

Thanks in advance and apologies for the newbie question!!

1 Solution

Accepted Solutions

Hi Silvana. This is a pretty common question. The IF function says that IF(expression, is true do this, otherwise do this). The false evaluation outcome is optional and will leave the formula result empty if not specified (or something like empty). Some like to use the “=BLANK()” when checking to see if a field is empty, but it’s not necessary.

IF({Start}, DATEADD({Start},90,‘days’))

Good luck.

See Solution in Thread

1 Reply 1

Hi Silvana. This is a pretty common question. The IF function says that IF(expression, is true do this, otherwise do this). The false evaluation outcome is optional and will leave the formula result empty if not specified (or something like empty). Some like to use the “=BLANK()” when checking to see if a field is empty, but it’s not necessary.

IF({Start}, DATEADD({Start},90,‘days’))

Good luck.