IF then statement

dsmartsheetuser
edited 12/09/19 in Formulas and Functions

Hi,

Fairly new to smartsheet, I am looking to do the following:

If 'Drop Down A' is set to 'No', then set 'Date Column B' = 'Date Column A + 30'

If 'Drop Down A' is set to 'No', then set 'Date Column D' = 'Date Column A + 14'

If 'Drop Down A' is set to 'No', then set 'Date Column E' = 'Date Column A + 7'

Appreciate the help!

Thank you,

Deepthi

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!