Help

Adding IF to DATEADD Formula

Topic Labels: Formulas
Solved
Jump to Solution
971 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Silvana_Marr-Ma
4 - Data Explorer
4 - Data Explorer

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
augmented
10 - Mercury
10 - Mercury

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
augmented
10 - Mercury
10 - Mercury

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.