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
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!