nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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,

Find more posts tagged with

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Can't access issue submission
I have run into an interesting but small bug. When setting up an automation, the action 'change cell value' will allow you to select checkbox columns, but not checkbox columns that are the star or flag visual variant. Those can't be selected in the change value action. Now the real issue. I go to submit a bug report or…
Setting up the welcome and help screens.
Hello All, I am having difficulties uploading my information to the welcome and help screens. We are a Micro Soft 365 shop, using share point, and I am getting the error message that share point in refusing to connect. Whereas this appears to be a share point issue; I have reached out to our IT Department, and we cannot…
Contact List validation
Hi Everyone, I am managing a pipeline tracking sheet, and there's one intake form and one dynamic view connecting with this sheet. For the column "Branch Contact" and "Sales leader", I set the filed type as "Contact list" and the validation as "No validation". Once I input the username in the intake form, I go to the…