Filtering on a Sheet

Jenn123

How do I do different levels of filtering on a sheet?

For example, I want to search by Project and only the Project Categories I have listed within that Project. When I bring up 11650S project, it shows all the Project Categories listed on the sheet. I only want to see the Project Categories I have listed with the 11650S project.

SmartSheet Filters.PNG

kowal

Hello @Jenn123

Unfortunatelly the filering lists are not dynamic when createing filters so it will always show all the values no matter what conditions you selected before.

Hope it helps.

Jenn123

Is there a way around this with an equation or something else?