Recreate a completed task before archiving
Hello!
We have a task worksheet that as a task is completed (Done field checked off), the task is archived to another sheet. What we'd like to be able to do is have that same task recreated on a new line before it is archived with the next due date. These are tasks that need to be completed either daily, weekly, or monthly. Is there any way to do this in Smartsheet?
Best Answer
-
There is no really pleasant way to do this. What I have taken to doing is creating backround colors in editable cells, using a copy to workflow instead of a move workflow, and telling the users to delete data in the colored cells after submitting.
Answers
-
There is no really pleasant way to do this. What I have taken to doing is creating backround colors in editable cells, using a copy to workflow instead of a move workflow, and telling the users to delete data in the colored cells after submitting.
-
Thank you! That's what we've been finding too - no easy way to do it!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!