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.
As rows get added & cell values change, it would great if we could automatically sort them in the sheets themselves instead of having to set up reports. Adding the ability to do this in a workflow would be a fantastic addition. Right now we have to do it manually.
Have their been any updates to this function being added? Can Smartsheet provide an update please?
Hi, I hope you're well and safe! Unfortunately, no, but it's still an excellent idea! Add your vote! I hope that helps! Be safe, and have a fantastic weekend! Best,Andrée Starå | Workflow Consultant / CEO @ WORK BOLD ✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
If this could be automated with specific triggers that would be exceptionally useful for managing large inputs of data!
Has anything more come of automatically sorting rows in smartsheet upon opening the datasheet view?
I agree that a persistant sort is needed.
I've read that you can do this via the API, but I haven't tried it yet. Would be great if it were an option within the application itself.
Adding in support for a persistent sort option! We have a sheet that has hundreds of rows and we need to be able to sort items based on a year column. It looks like this has been "On Roadmap" for quite a while now, is there an ETA for an update?
My use case would be solved with an automation that I can set to be triggered by "when new rows are added." Personally, I wouldn't want it to trigger when cells are changed in case it activates while I'm working in the row.
We need this functionality as well. For example, we need to manually sort a sheet for event registration by date, last name, first name. We also need to manually sort another sheet with events listed by date/event name.
I love (hate) how the interface got a new look, and the icons are all different colors, but I can't sort with a filter on or set a default sort for a sheet. Where's the functionality?
Is this still on the long-term roadmap? Any updated on timeline for release? @Serena Batten
I would love to have either:
Both of these (especially working together) would save me lots of time and frustration between all my sheets. (Mostly because I have to sort so many sheets and them and add rows and then sort again and repeat).
I too would like a sheet to auto sort based on my sorting preferences. Each time i add a row i have to remove my filters, right click the appropriate first level column, choose my next 2 criteria and hit go. Would be lovely to just be able to set it on the sheet and have it do so on refresh each time without me manually walking through the process. Reports wouldn't be good as it's a very active sheet with data entry on individual rows a lot. (We use it to track production and machine progress)
This would be an excellent feature and apparently vital to a lot of organizations.
Hi everyone, I created a browser extension that adds automatic sorting into SmartSheet. You can can click here to download the browser extension.
Then click "Sort Rows":
Then click "Sort Automatically":
Then the browser extension will automatically sort whenever the data changes. The browser extension also saves your sort settings, so that you don't need to manually re-enter them.
Also, this automatic sorting works with filters. So if you enable automatic sorting, and then add a filter, the extension will automatically sort the data even with a filter enabled.
I hope some of you find this useful!
Sign in to comment or add your vote.
