Multiple filters

Elizabeth

Hello community,

I am a newbee to Smartsheet. I am creating a content pipeline for our unit and am looking for a way to apply multiple filters to one column. For example in my "Audience" column, I would like to filter for each individual audience (we have about 30 in total) but if possible also for two or more audiences at the same time (eg. Trustees and Followers).

Is there a way this can be done in smartsheet, without having to create 30 individual filters?

Thank you!

Andrée Starå

Hi @Elizabeth

You could create one filter and then update it each time to show what you need.

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Do you have access to sheet summary fields?

Elizabeth

Yes I do:

Paul Newcome

How many different options do you want to filter on?

Elizabeth

So far we have 24 different audiences we would like to filter individually but it is likely that more will be added in the future. Ideally I am looking for a similar function as there is in Excel where you can filter each column for as many options as needed.

Is there a way to do this in smartsheet?

Andrée Starå

Hi @Elizabeth

You could create one filter and then update it each time to show what you need.

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Elizabeth

Hi Andrée

Yes, I suppose that could work. Thank you!

Have a great day

Elizabeth

Andrée Starå

@Elizabeth

Excellent!

You're more than welcome!