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 - The browser extension that adds essential features into Smartsheet.