Dynamic Future Date based on Condition
Hello,
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.
Comments
-
How many different phases do you have? If it is only a few, a nested IF statement would work. If you have more than a few, I would suggest setting up a table and using an INDEX/MATCH formula.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!