Filtering and sorting at the same time

tfassnacht

Hi community,

 

When applying a filter I cannot filter the filter result.

 

 Any clue how to work this around ?

 

Best,

 

Paul Newcome

You can add multiple conditions to a filter.

tfassnacht

I found this can be done with a report but not a sheet.

 

Smartsheet: Room for Improvment !

Andrée Starå

Hi Thomas,

That would be a great enhancement!

Please submit an Enhancement Request when you have a moment.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

I'm not understanding how this cannot be done on a sheet but can be done in a report. I don't have an option to filter a report other than editing the report builder criteria.

 

In a sheet you can select multiple requirements to be built into a filter. I was just testing to see what would happen, and I was still able to continue adding criteria after the 15th condition. I stopped there, but it seems like any report you can build (off of a single sheet) can also be filtered for within the sheet itself.

SSFeatures

Hi @tfassnacht, I recently built a browser extension (SSFeatures) that lets you sort even when you have filters enabled.

You'll notice that you will be able to click the "Sort Rows" button, even with a filter enabled.

Hope this helps!