Date Formula
Hello is there a function where a date can be calculated based off a selection from a drop down in another column. For example, if someone selected a status saying "In approvals" which takes 5 days to complete can Smartsheet calculate 5 days from today's date and display that date in another column?
Best Answer
-
@Folkes I'm glad that worked. See below to include different statuses.
=IF([Status]@row = "In approvals", TODAY() + 5, IF([Status]@row = "Authorizing", TODAY() + 7, IF([Status]@row = "Testing", TODAY() + 10)))
Isis Taylor
Business Analyst Senior
Answers
-
@Folkes Try this.
=IF(Status@row = "In approvals", [Status Date]@row + 5, "")
You could also try this.
IF(Status@row = "In approvals", TODAY() + 5, "")
Isis Taylor
Business Analyst Senior
-
@Isis Taylor It worked! Thank you so much. I do have another question; how do I write the formula if there is more than 1 selection from the drop down. For example, "In approvals", "Authoring", "Testing". Each one has a different time it would take to complete.
-
@Folkes I'm glad that worked. See below to include different statuses.
=IF([Status]@row = "In approvals", TODAY() + 5, IF([Status]@row = "Authorizing", TODAY() + 7, IF([Status]@row = "Testing", TODAY() + 10)))
Isis Taylor
Business Analyst Senior
-
@Isis Taylor you're amazing! Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!