Formula on deleting the entire rows if the checkbox is ticked

trishhfernandez

Hi Team

Is there a way that the rows can disappear after we’ve ticked them delivered please?

 

 

 

Andrée Starå

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

Alison

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