Add 'sort order' to Filter Views

RhondaRhocks

A longtime Smartsheet user and have always thought this would be an easy fix. It does feel like a moment way back in time and difficult to WOW new users with this much needed feature.

Jenn Moffett

this is a big barrier for adoption for us. looking forward to the escalated roadmap timeline.

SebastianScholle

This is definitely a feature we will be using, when it's available.

Please will this be prioritised in the Dev timeline.

DaveD

I agree. We are trying to use Dynamic Views for review meetings and having to manually sort every time the filter is changed is tedious and disruptive to the meeting participants and stakeholder.

Marcus99

It would be great if you could use the Sort Row function with a criteria option also.

For Example:

If I had a range of open and closed requests that have different due dates.

Sort rows by "Due Date" with due soonest showing at the top but only the rows where the closed box has not been ticked, the rows that are "closed" would show at the end of all the "open" rows.

Genevieve P.

Hi @Marcus99

You can currently apply up to three Sort criteria. In your case, you would put "Due Date" as your first Sort, then "Closed" as your second sort criteria.

So if my sheet looked like this:

Then I apply the Sort so it looks like this:

Is this request for more than 3 criteria?

Marcus99

Ah sorry, I explained poorly.. Closed/Open in this case is a drop down option in a cell.

Whereas I can do the due-date I am unable to sort by what is said in a cell.

Genevieve P.

Hey @Marcus99

You can sort by a dropdown list as your second option, no problem!

As you can see, there's a small note that says that Dropdown Lists will sort in the list order that you have identified in the column's properties (double click the column). So in my case, I sorted it like above for a result of:

Does this help?

Sam Sandy

Please add this function. It is very much needed!

Marcus99

This did help, thank you but its not a "filter" that can be saved - maybe an addition to this suggestion would be the ability to save sort functions?

GrantKiwi

Is there still no comment from Smartsheet on this missing feature? Our users have taken to exporting to Excel just to enable them to slice and filter the data to their requirements. This may actually drive us away from Smartsheet despite all of the other great features. I'm assuming it's nearly impossible due to the existing architecture and system design.

David Hunt

Does anyone even monitor these request? Looks like this has been a repeated ask since the first post of Oct 2022! I'm not a programmer but this seems like it would take very minimal effort to implement. VERY MUCH NEEDED!

Lauren McMahon

Do we have an update on the timing for this one?

This would be massively impactful to the usefulness of the tool.

Ide AirTrunk

Would significantly reduced the number of reports needed to meet this need!

Lori Cross

The ability to sort a column in a sheet when you are using filters.