Delete Rows using an Automation
Options
Comments
-
I agree that this feature is needed.
-
Moving to a 'archive' or 'dump' sheet just moves the problem down a step. Ultimately you need to delete rows to avoid a chain of multiple archives of archives of archives... Logically we need to delete at some point.
+1 on others calling for this option.
-
Need a way to setup an automation to delete rows by trigger or schedule date.
-
To automatically delete rows in an "archive/trash bin" sheet I do this. I use a standard "move" automation template to move the rows into a newly created "trash bin" sheet. Using Data Shuttle I do this:
- Create an Upload workflow.
- The source file will be a blank .xls or .csv with the identical structure as your regular data import file - but blanked out, no data.
- Configure the workflow for complete replace of the target sheet (the "delete bin" sheet).
- Schedule the new delete bin workflow frequency greater than the frequency of your data import. For example, if you upload your data every hour, then empty the trash bin every 15 or 30 minutes. I do this to reduce the chance that I could "overflow" the trash bin and halt the automation.
-
I believe it would be helpful to add an Automated Option to Delete Rows, we currently have Move or Copy Rows to another sheet when certain criteria are met and then manually deleting them in the new sheet. This requires creating an additional sheet and manually deleting them (time consuming plus added tasks). With Automated Delete Rows option, we would select our conditions to when these rows would need to be Deleted form the sheet (task completed, or Date reached).
Best Regards,
-
I would absolutely love to see the addition of a "delete row" automation, but I will definitely be implementing your workaround for now. I have been setting up multiple "trash" sheets, but this would allow me to use only one and data shuttle it back to empty daily. Great solution!
-
Such a simple workaround. Thanks for posting.
For the record, I would also like the ability to delete rows natively in smartsheet
-
Hi all,
Hopping in here to let you know that this functionality is currently possible if you have access to Bridge!
Here's a new Help Article that goes through the steps on how you would set up this Bridge workflow:
Cheers,
Genevieve
-
This is my first post, so please let me know if you see any areas for improvement.
I'm not sure if this is a result of Smartsheet or if it's due to the way I've set up my automations. I'll explain how I've set up my current sheets, which are being pulled through the "Move" automation to an Archive sheet. The Archive sheet has conditional formatting set up with a combination of formulas to count the total cells. Once I reach a certain number of cells in the Archive sheet (typically 30-60 days worth), I have another automation to clear the column. This automation clears all of the necessary columns, and my formulas restart for the next inbound batch. It's a bit of a chain reaction effect for supplemental workflows.
This was a bit difficult to set up initially, but it's been perfected with each version update. Please let me know if you have any questions!
-
I appreciate all the workarounds people have posted, and I use several variations across different sheets and workflows.
However, I would still like to have an action for "Delete Rows" as an option. There are cases where this really is the right answer, and it seems like a low-hanging fruit for the development team to add.
#SmartsheetSuperstar
-
We need this feature as well.
Thanks.
-
I agree with this. I have replicated a sheet throughout our organisation (set up by location) and all past date information gets moved to a separate sheet (again by location). However, if there are certain fields that are left blank, then I do not want it to go to those sheets.
Due to the sheet limitations and the size of my sheets, I do not have time to delete the information manually over the 16 locations.
Thanks
