Formula on deleting the entire rows if the checkbox is ticked


Hi Team

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






  • Andrée Starå
    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!


    Andrée Starå - Workflow Consultant @ Get Done


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Alison
    Alison Employee
    edited 06/26/18

    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.



    Smartsheet Support

    Screen Shot 2018-06-26 at 11.17.48 AM.png

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!