Formula on deleting the entire rows if the checkbox is ticked
Comments
-
Hi Trish,
You could use a filter or maybe a report to only see the rows that are relevant, but i noticed that you have something that needs to be deleted so my recommendation then would be to use a service like Zapier to move the rows to another sheet and then delete the rows from there.
Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Trish,
Andrée's suggestion is great! I've also done it on my own sheets where I have a top row as a Parent row with our Hierarchy function. When I am done with the next line item, I indent it, which brings it under the collapsed parent row. However, you would have to rearrange any rows that you complete that are not directly under the parent row when all child rows are collapsed. This would hide the rows instead of deleting them, but it may work for you.
I attached a screenshot just in case.
Alison
Smartsheet Support
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!