Filter a list dynamically

Ask for Help
1

My app has users filling out a survey, and the app should display items based on the survey responses. For instance my survey could have 3 yes/no questions, and I have a table with items that should be displayed based on the answers to those questions (e.g., display when Q1=yes, Q2=Yes, Q3 - any answer)

I don’t see a good way to do this. My thought is to enter the survey responses into a new sheet, and then do the appropriate filtering. This looks kludge-y, and I’m not even sure it will work. Any other suggestions?

2
3

Thanks. I did this by putting my (user-defined) selection columns in a separate table, and then created a single-value column in the base table that referenced the table with the selections (first row). I’m guessing that this isn’t correct, that they need to be the same table, but just checking before I correct the whole mess.

4

It doesn’t need to be the same table, and when I need to do something like Robert taught in the video, I kept the choices in another sheet as well.