Dynamic Future Date based on Condition

edited 12/09/19 in Formulas and Functions


Issue: I need to create a date column that will produce a forecasted date, based on a manually entered date plus X amount of days, based on a certain value (phase). Example: 

If Phase is "SOW Draft/Negotiations", add 60 days to the "Phase Modified Date" (60 days that will dynamically update everyday, so today will be 60 days, but tomorrow it will be 59, and so on). 

I've tried multiple formulas, but nothing really comes close to what I need. I can use an IF formula, but the main problem I have is with the dynamic date. 

Any help or guidance is greatly appreciated. Thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!