Is this even possible?
I have a process document with columns with start dates and due dates. The process steps do not change from year to year. What I would like to do is trigger some action or create a formula that once an item is checked complete, the start date and due dates advance by 365 days. It would be great if the complete box was then unchecked.
This type of automation would be very helpful as this information feeds a roll-up report of all the upcoming dates for a variety of processes that reoccur annually.
I am grateful for any advice. Also, please tell me if this is pie in the sky thinking.
Thank you,
Mary Pat
Best Answer
-
I don't believe this is possible at this time without the use of some 3rd party tool like Zapier. But it's an interesting idea! Please submit a product enhancement request and let them know how you'd like this to work!
Answers
-
I don't believe this is possible at this time without the use of some 3rd party tool like Zapier. But it's an interesting idea! Please submit a product enhancement request and let them know how you'd like this to work!
-
Will do, thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!