For those looking for a solution until Smartsheet gives us a better way... if you know how to use the API (via Power Automate or something). If you do not need to retain an archive at all and just need to delete, you can do this:
- Move the Row from the Main Sheet to an Archive Sheet
- Set up Power Automate to run an action whenever a new row is added
- Execute the Delete row API call to delete the row that was just created in the Archive Sheet