Sign in to submit new ideas and vote
Get Started

Automatically Sort Rows in Sheets

1235»

Comments

  • Jamie Ide
    Jamie Ide ✭✭✭✭✭✭

    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.

  • Chris_C
    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
    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
    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
    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.
    Lisa F. ✭✭

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

  • 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.

  • SSFeatures
    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!

    Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)

    SSFeatures - The browser extension that adds more features into SmartSheet.

    • Report PDF generator that supports grouped and summarized reports
    • Automatic sorting, sorting with filters, saving sort settings
    • Hiding and unhiding columns, and spell checking