Sign in to submit new ideas and vote
Get Started

Add 'sort order' to Filter Views

13Β»

Comments

  • KCI
    KCI ✭✭✭
    edited 06/21/24
  • Helena P.
    Helena P. ✭✭✭✭

    it would be very helpful being able to filter sheet after applying filters.

  • dojones
    dojones ✭✭✭✭✭

    Create method to auto sort a filtered sheet. If date is selected for sorting and Status field is filtered to Open. Current method is to turn filter off, select date field, select sort, select OK, change filter back to Open. I would like an automatic sort/workflow to accomplish this.

  • afarias
    afarias ✭✭✭

    I am unable to sort while a filter is on. This is inconvenient. This is basic Excel functionality today. This should be updated within the new grids asap.

  • spauliszyn
    spauliszyn ✭✭✭✭

    Me too. I would love to see specific sorting depending on certain saved filters. However, there may be too many combinations to rely on sort parameters in saved filters. The sort feature should /also/ be independent from the filtering. So once you select your filter, maybe you also have a sort associated with it. But you may want to reverse the sort on the fly, WITHOUT having to alter the saved filter.

  • SSFeatures
    SSFeatures ✭✭✭✭✭
    edited 04/09/25

    Hi @dojones, I created a browser extension that adds automatic sorting into SmartSheet and it supports filters. You can canΒ click hereΒ to download the browser extension.

    Then click "Sort Rows":

    ssfeatures-auto-sort.png

    Then click "Sort Automatically":

    ssfeatures-auto-sort-checkbox.png

    Then the browser extension will automatically sort whenever the data changes, even if you have a filter enabled.

    The browser extension also saves your sort settings, so that you don't need to manually re-enter them.

    I hope this works for you!

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

    SSFeatures empowers Smartsheet by adding essential features into Smartsheet to save you time. For example: β€” Auto Sorting β€” Sorting with Filters β€” Report PDF Generation β€” Copy and Paste Conditional Formats β€” Copy and Paste Automation Workflows β€” Column Manager β€” and so many more.

  • KMH Spinner
    KMH Spinner ✭✭✭✭

    Adding my vote to this request. It's really inefficient to have to turn off my filters to sort!