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
🎓️ Core App and Project Management Certified 🏅
🌟Peer Connect, Mobilizer, and Early Adopter Program
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
🎓️ Core App and Project Management Certified 🏅
🌟Peer Connect, Mobilizer, and Early Adopter Program
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
🎓️ Core App and Project Management Certified 🏅
🌟Peer Connect, Mobilizer, and Early Adopter Program
Business Analyst Senior
-
@Isis Taylor you're amazing! Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!