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?