YES!!
it would be very helpful being able to filter sheet after applying filters.
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.
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.
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.
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":
Then click "Sort Automatically":
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.
Adding my vote to this request. It's really inefficient to have to turn off my filters to sort!