Add 'sort order' to Filter Views

JPJPJP · 10/17/22

I love the Filter Views feature in Smartsheet, but it would be really useful to include Sorting options in the Filter View dialog as well. Some of my filter views require sorting by different columns, and currently it's a bit annoying have to manual sort each time I change a view.

Alon Moshe · 11/30/22

Currently its not allow to do Sorting while filter was activated.

its not connivance and it required to switch off the filter each time i want to sort.

Marc Shecter · 12/21/22

@Alon Moshe -thanks for posting this. I've never understood this limitation in Smartsheet. I'm assuming the developers have a good reason for it. But the lack of flexibility makes Smartsheet's filtering and sorting functionality lag behind the competition like Google Sheets, Excel, and Quip, to name a few.

-Marc

Kam Pierce · 12/23/22

I understand this frustration, and have since started to use Reports for this reason because rows are automatically sorted regardless of when they are added to sheet (another feature that isn't available in Grid Sheet).

Dean Hayes · 01/17/23

I have the same request. Having this feature would reduce the number of reports needed to meet needs.

cabeaudoin · 01/25/23

I have the same request, very much needed.

AnneV · 02/17/23

This, or the ability to sort by selection, or the children under a parent row, would be very helpful.

Courtney S. · 05/17/23

Please add sorting to sheet filters. It would be more like the "filter view" options in google sheets and M365 sheets, and helps solve the related issue of no way to set up a default sort or automated sort for sheets.

Especially with the way that sheet filters are used for Dynamic View, adding a sort order to a sheet filter would make Dynamic View more useful & easier to implement. Right now, using a sheet as a Dynamic View source is great for using the sheet filters, so a lot of views can be built from the same source sheet, but all users are stuck with the sheet's sort order, rather than a sort order that makes sense for their view. Using a report as a Dynamic View source lets us set a sort order that differs from the sheet, but the lack of saved filters in reports means that we have to create a new report for every single dynamic view, which feels annoyingly redundant. We were hoping to replace reports with dynamic views, not build a new report for every view.

jan aelbrecht · 07/14/23

HI, any news on this as we think that this would be a great feature.

We have a dynamic view with 3000 lines and created some filters. all ok but it would be very usefully to have the option to search for a certain lines in the view.

so have the option to a filter per column in the dynamic view.

regards

jan

Celia Gust · 07/19/23

I would also like to be able to build sorting into filtered views. And, if we can have multiple sort levels that would be all the better!

DebRichardson · 07/26/23

Love this idea....This would be super helpful

John Pammant · 07/27/23

I agree with this request.

I would also like to have sort option for Dynamic View.

GrantKiwi · 09/11/23

This is a big missing feature. Trying to convert Excel users to Smartsheet, then explaining you can't sort a filtered list always feels like a backward step and impacts adoption for us.

GrantKiwi · 09/11/23

I also would REALLY like a second filter field as well, to reduce the proliferation of saved filters.

Phillip Stringer · 09/19/23

To have the ability to build filters with the sort function also would be a tremendous help. This is what I miss the most from Excel. I have macros built on my spreadsheets to sort various columns at one time as well as filter multiple columns. To have to go through and sort each column manually before I use my filter is really annoying compared to excel. Please add the sort feature to the filter section...

drichart · 10/12/23

It would be a great addition to be able to sort the columns alphabetically as needed (ex: sort A-Z, Z-A, High to Low, etc.). Currently, you have to turn off all filters to sort and then get back to where you were, which is a bit cumbersome and time consuming.

Has anyone discovered a faster way to sort columns on a sheet grid?

Smartsheet Product Feedback & Ideas

Smartsheet Product Feedback & Ideas

Sign in to submit new ideas and vote

Add 'sort order' to Filter Views

On Roadmap · Last Updated 01/22/25

Comments

FAQs and Guidelines for posting Product Feedback Ideas

Quick Links

Categories

Trending Ideas

Rand() function

Toggle Column Filters

Feature to exclude blank fields from automated alerts and requests