Add 'sort order' to Filter Views

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.

Sign in to vote!

Find more posts tagged with

Sheets

On Roadmap

Comments

Alon Moshe

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

@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

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

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

cabeaudoin

I have the same request, very much needed.

AnneV

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

Courtney S.

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

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

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

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

John Pammant

I agree with this request.

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

GrantKiwi

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

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

Phillip Stringer

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

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?

Quick Links

Trending ideas

Report Widget Capability - Drag & Drop to create Report Widget in Dashboard from Workspace Panel
Hi, I was creating new dashboard and thought it'll be so nice to have easy drag and drop Report widget capability from Workspace Panel since I always group set of reports under one folder (for ease of finding them what goes on the dashboard). I think this would be great time saver especially if you have similar name…
Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
Asset Sharing should default to View, not Edit
Since the license model has changed, the option to Share should default to VIEW, not EDIT. The View option allows less-experienced users to share that way by default, and share as Edit only when needed. This allows for less cleanup during true-up. This also prevents users from adding provisional licenses unknowingly.