Smartsheet Product Feedback & Ideas

Smartsheet Product Feedback & Ideas

Help shape the future of Smartsheet! Share your feature wishlist and improvement requests here.

Sign in to submit new ideas and vote
Get Started

Automatically Sort Rows in Sheets

1235

Comments

  • Community Champion
    edited 06/09/24

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

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

  • ✭✭✭✭

    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

  • ✭✭
    edited 10/03/24

    I would love to have either:

    1. A way to save a particular sort, so that if I add rows via forms I can click a button and sort all my rows with a default sort (rather than go through the process of sorting by three different columns every single time I need to sort my sheet
    2. An option to enter the row in chronological order by a date field. For instance, I tack what tasks I need to complete by adding them via form. If I could find a way to add new rows in particular spots so that they are already in chronological order when I go to begin my days or to check off the task.

    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!

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

    SSFeatures - The browser extension that adds essential features into Smartsheet.

  • ✭✭✭

    Would like to have the ability to auto-sort in sheets, especially when setting up filters. Mimic this ability in Reports.

Trending Ideas