Please create automation to delete Rows. Using the move rows automation, we are able to move records to an archive sheet. The problem then becomes we have to manually delete records from the archive sheet.
Sign in to see the current vote count, add your own vote, or leave a comment.
Agreed. I like the Move Rows option to archive, but at some point it would be nice to automate deleting rows after they become 'old'. We've had situations where users inadvertently deleted way more than intended when manually going into the sheet as they didn't realize what filter was on (or off). Having the human element removed would be great. 🗑️
@Ian Cooper @Jake Gustafson
I agree this would be a great feature.
One workaround when move row is to use a Data Shuttle replace all with a blank excel to clear the archive sheet on a set schedule.
Are there ways for a common Smartsheet user (without any of the premium add-ons) to automate deleting select rows from an archive sheet? We archive records daily and weekly depending on the scenario, but we want to retain records for a certain period to show metrics, but after they age so much, then we want to delete them. Manually doing this requires training and trust that those users don't inadvertently delete extra rows.
I'm not skilled in the arts of APIs or something like Microsoft Power Automate to automate a practice like this. But I'm assuming someone out there has done something similar.
@Jake Gustafson My only suggestion would be to add yet another sheet beyond your archive sheet. Use a date based move row to from you archive to the new garbage sheet. Now anyone can just delete all the data without making a mistake
Hi! Product Manager for Automated Workflows here! Love seeing this interest in the feature, but I am surprised to see it here:) ! We do recommend setting up a Move Row automation - this way you have control over when data is deleted - you know in the case of accidentally setting a value that would fire this workflow.
But I'd love to hear if this doesn't work for your use case. Here's a link to my Calendly -https://calendly.com/urmila-kukreja/30min . I'll be grateful if you can grab some time- I'd love to hear how you use workflows and how delete row automation would help your process.
@urmila.kukreja
While accidently deleting something is a possibility I would still want the option to do it. Give us the tools and allow us to assess the risk.
Personally, I'd rather setup automation that will delete rows consistently based on the rules set, rather than depending on a person to choose the right rows when retention is past.
I agree with many others - Need the ability to Delete rows via automation just like Move and Copy.
We have very large datasets. My archive sheets often hit the row limit if I do not delete the rows that we no longer need. Having a delete function is critical.
Additionally, it would be GREAT if you updated your API to allow us to pass Row #s to delete in the body of the API call rather than in the URL. Because of the length limitation of a URL, I can only delete around 300 rows at a time via the API. However, if I could pass all 20,000 rows in the body of the call, I could easily clear the sheet in a single call rather than having to iterate and make 60+ calls.
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:
Hi Ramsay
I use Power Automate to achieve some things that Smartsheet automation can't (my favourite is creating a sheet of the URLs to a sheet that I can reference as a table to enable users to quickly go to a sheet relevant to a project), but how do you get Power Automate to delete a row?
Any help appreciated in keeping my "Dump" sheets cleared down!
Add me to the list of users that would love to have the ability to set up a "Delete Row" automation.
Moving rows to a trash sheet and then manually deleting them seems pretty counter-intuitive. Why set up an automation to move something that you are, ultimately, going to have to manually delete?
@Roland Horwood @Kyle Morgan I created a Smartsheet app that automatically deletes rows for you at WorkflowCreative.com Please let me know if you want to test it out. -Ryan
We need this feature please
Dashboard widgets are currently mostly static. I can display counts and charts, but I cannot click into a specific part of a widget to drill into the underlying records. It would be a big usability improvement if widgets supported interactive drill-down. For example: Click a bar segment (or stacked segment) to open the…
I had Technical Support Case #09045069 in relation to this issue. I was told to get the API documents corrected, I needed to post to here. Update API Documentation Some (all?) of the API calls related to Alternate Email Addresses require both an Enterprise Account and to be manually activated by Smartsheet Support. The API…
Dear Smartsheet, You really need to add an administrator-controlled option to manage the license banner display for free users. The banner not being able to be removed by the administrators presupposes that the administrator wants the free users to have licenses. One of the main reasons we love Smartsheet is the ability to…
