Thinking Through Approach

I need help thinking through an approach in Smartsheet. We have a master list of questions in this "Questionnaire" excel sheet for when we do internal assessments across the different businesses in our group. Depending on the make-up of the businesses, we customize this questionnaire for each assessment. I am trying to automate this by putting in key indicators next to each question. Originally, I thought we can just use the simple column filter functionality in Excel. However, I believe there is a better way to approach this. I am imagining the scenario where a person on my team answers about 4-5 questions or (selects 4-5 indicators in a menu) and the output is the list of the exact questions we need. Any thoughts on the structure of this idea within the Smartsheet platform?

Answers