Automate a response field
I would like to automate a due date of 5 weeks from the creation date unless the status is “On Hold”. Then the date should be blank. When the status changes from “On Hold” to "Open" then the date can be recalculated as above. Unclear how this can be done.
Tags:
Comments
-
Change the column names to match your column names. Add the formula to your Due Date column - ensure that it is setup as a Date column.
=IF([Status]@row = "Open", [Created]@row + 35, "")
This is giving you a date if status = Open, or blank for any other status.
Hope this help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!