Automatically Sort Rows in Sheets

Ide AirTrunk

If this could be automated with specific triggers that would be exceptionally useful for managing large inputs of data!

Jeff at UVAH

Has anything more come of automatically sorting rows in smartsheet upon opening the datasheet view?

bsheffron

I agree that a persistant sort is needed.

Bo Lewis

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.

Chris_C

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?

beckyb

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.

Jeff1

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.

CAS the CSA

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?

Lisa F.

Is this still on the long-term roadmap? Any updated on timeline for release? @Serena Batten

crathier

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)

mstrohecker

This would be an excellent feature and apparently vital to a lot of organizations.

SSFeatures

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!