Help

Dateadd with If formula

Topic Labels: Formulas
1545 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Janet_Shivell
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi

I am trying to add a formula that will show a renewal date 3 years from the subscription date (yr 1) but not show anything for implementation period or yr 2, yr 3.

IF ({Impl /Sched Fee} = Subscription Yr1), (DATEADD({Inv Date}, 3,’ years’), "None ")))

I continue to get errors on this formula

2 Replies 2

Welcome to the community, Janet! :grinning_face_with_big_eyes: I see a few possible error points in your formula:

  1. There can be no space between IF and its opening parenthesis. IF is a function, and all of Airtable’s functions require that the function name be immediately adjacent to its opening parenthesis.

  2. You’ve got extra parentheses wrapped around certain parts of the IF function. The basic IF function syntax is:

    IF(condition, result-if-true, optional-result-if-false)

  3. I’m guessing that “Subscription Yr1” is a field name. Because it contains spaces, it needs to be wrapped in curly braces (it’s kinda handy that this rule rhymes :winking_face: )

  4. You need to remove the space at the start of your ’ years’ specifier, or else DATEADD won’t recognize it. This won’t throw an error, but it just won’t calculate the addition.

With these changes, the formula should look like this:

IF({Impl /Sched Fee} = {Subscription Yr1}, DATEADD({Inv Date}, 3,'years'), "None")
Janet_Shivell
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you so much this worked great!