Reply To: Deleting Rows from a Report

Inner Circle › Ask Smartsheet Guru Crew Anything › Deleting Rows from a Report › Reply To: Deleting Rows from a Report

#644
Darren
Keymaster

    That would be the way to do it using the built in automations. Then you’d have to clean up the deleted rows sheet, should you need to actually delete the data.

    Similarly, if you actually wanted to delete the data in one shot, you could use Bridge or Power Automate to delete the rows that have the box check. That may be dangerous if just a general user can check the box though!!!!

    Using your method above, you’d have a way to ensure the deletion was intended and restore if necessary..

    Have done this trick to allow users to replicate a row from a report
    1. Check a box to duplicate the row
    2. Automation copies the row to a holding sheet
    3. Automation on the holding sheet moves the row back to the original sheet

    Then you end up with an exact copy. This is useful for some use cases, but is rather a bit of a hack. I learned this from another Smarthseet developer.