# If Statement to calculate date

Options
edited 01/10/22

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

• Employee Admin
Answer ✓
Options

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)))

Cheers,

Genevieve

## Answers

• Options

Believe I figured it out. No = before [Term Date]@row + 30)

• Options

Am having issues linking multiple statements.

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

Returns Unparseable.

• Employee Admin
Answer ✓
Options

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)))

Cheers,

Genevieve

• Options

Exactly what I needed, Thank you Genevieve!

• Employee Admin
Options

No problem! 🙂

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!