Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to see the current vote count, add your own vote, or leave a comment.
There is currently not a way to clean up data tables efficiently, only continue adding data to them. Would be good to be able to run some type of clean up on the table to remove data that is no longer needed. This would also help free up server space.
Hi @jpaul
Thanks so much for the feedback, would love to connect with you on this topic as it's something we are investigating.
@jpaul I need this too! thank you
@jpaul If you're going to be at Engage, come by and chat with Holly and me at the Data Connections booth! We'd love to get some more feedback from you on this.
Yes, please! We need the ability to automatically remove bad data from DataTable. My workaround is to put a "Record date" field on each record in the source. I use the DataTable connection filter to only include records with a "Record date" field = to the update frequency of the data. For example: - if the data refreshes daily, the DataTable connection filters records with a "Record date" = today or yesterday. - if data refreshes every 3 days, the DataTable connection filters records with a "Record date" = 3 days ago or 4 days ago
Including one additional day reduces data accuracy but ensures date mismatches between Smartsheet and the data source don't remove data.
@Danielle Wilson have there been any developments on this? We really need to be able to delete more than 100 rows of data at at a time. A "Select All" option on filtered data for deleting rows in the DataTable would manage this nicely.
@Brad Powers Nothing that I've recently heard back from the team but I'll pass along the feedback!
@Holly Rumble, would love to connect with SS and show the use cases.
@jpaul I'll follow up with you over email!
So Im having the same issues with Data Table not removing data that is no longer in the source file, this is a huge problem to keep data accurate and to be able to be used in Sheets & Dashboards without counting data that is not valid any longer. I do have a tendious work around but it involves creating more data shuttles and then using the data Table to pull the remaining data into sheets. But this really should be a feature of SS.
Sign in to comment or add your vote.
