Filtering on a Sheet

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.
Answers
-
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.
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
-
Is there a way around this with an equation or something else?