Remove completed tasks
Hello,
On my sheet using the Status feature, is there a way to have the tasks marked completed removed from the sheet and stored elsewhere? I tried a couple different things but ended up with a report showing the tasks marked completed. I don't want it to copy over, but switch sheets all together.
Best Answer
-
It may take a little while before it is found by the search. I would suggest giving it some time, refreshing your browser, then checking again. If it is still not there within an hour, I would suggest reaching out to support.
Answers
-
@Nmlateulere You can set up an automation using the "Move a row to another sheet when specified criteria are met" feature. The condition can be when Status is Complete.
Isis Taylor
🎓️ Core App and Project Management Certified 🏅
🌟Peer Connect, Mobilizer, and Early Adopter Program
Business Analyst Senior
-
You would set up a second sheet and then (on the first sheet) set up a move row automation triggered when the status changes to completed.
-
Hello,
I have tried to set up an automation, but for some reason it's not finding my "Completed" sheet.
-
It may take a little while before it is found by the search. I would suggest giving it some time, refreshing your browser, then checking again. If it is still not there within an hour, I would suggest reaching out to support.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives