Enum column Filter?? Help!

[Diram0909]

Hi Everyone! 

I am making an Audit app and have encountered a blocker in my learning journey. In the App, I can create audits. Audits can have many issues created inside. These issues can be prioritized and categorized.

My spreadsheet

• Tab 1 is Audit (Audit Name[key], Evaluator name, date of audit)
• Tab 2 is Issues (Audit Name, Issue category, Issue priority, Issue Image, Description, Fix Recommendations) 

I want to create a view where I can show a bar chart of Issues per category and another one of issues per Priority BUT the thing is I want to filter by a specific Audit Name. 

Is there a way for my users to have an Enum list of my Audit Name column so I can filter my Issues according to that?

How can I add that to my view? I'm sorry, I'm such a noob here and I don't really know how to program. 

[TeeSee1]

You can do something similar to this...

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/UX-questions-complex-search-filtering-sorting/m...

Basically you

• Create a filtering conditions table.
• Create a slice based on the conditions table above.
• Create a view based on the slice.