If Statement to calculate date

edited 01/10/22 in Formulas and Functions

Termination form:

Termination Date captured in [Term Date]

[Duration - Phone/Email Forward] single drop down selection 0 days, 30 days or 60 days

I would like a [Disable Forward Date] to be generated based on selection of [Duration - Phone/Email Forward]

Here is my attempted formula/function-

=IF([Duration - Phone/Email Forward]@row = "30 Days", =[Term Date]@row + 30)

Will need to create one for "0 Days" and "60 Days" as well.

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @JohnFesler

    You're close! When you list multiple IF statements, don't close off each IF formula with a closing ) until the very end of the statement... this keeps it open so that if the first statement isn't True, it moves on to read the next statement.

    Try something like this:

    =IF([Duration - Phone/Email Forward]@row = "0 Days", [Term Date]@row, IF([Duration - Phone/Email Forward]@row = "30 Days", [Term Date]@row + 30, IF([Duration - Phone/Email Forward]@row = "60 Days", [Term Date]@row + 60)))




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!