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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!