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

Data is missing
Hello, I created a Smartsheet Project yesterday (trial 30 day user). I input all relevant information including due dates, status, priority, etc. I returned from work just now and logged in to update something on the sheet and all info is missing. I can see the Project Folder but all rows are empty. I tried troubleshooting…
Can you do a portfolio report on manually created project sheets?
I have a portfolio with 1 project template. I created 2 projects from the project template. I realized I need a Project Metadata sheet to facilitate the portfolio reporting I need. So I added a Project Metadata sheet to the project template and manually to the 2 projects previous created from the template. I've confirmed…
Users incorrectly labelled as "External"
Hi Smartsheet users. We have a number of users who are being labelled in the "Seat types and true up" screen as "External". They all have the same email domain, which is different from the domain of users who are not flagged as External, however both domains belong to our company and are listed as verified under the…