Display rows on a sheet based on survey results
new to Smartsheets and a little lost so appreciate anyone who can point me in the right direction. I am working on a risk assessment and have imported a set of questionnaire responses (questions in column 1 and answers in column 2) into a grid. 90% of the answers are yes/no. I have a second grid that contains a list of risks (each row has multiple columns e.g. threat, vulnerability, risk statement, control...
What I am trying to achieve is that when I import a questionnaire response, I can generate a new sheet (report) with a list of risks that are triggered depending on the responses to the questions. Most questions would trigger a single risk (depending on the response) but some questions trigger multiple risks.
I hope my description makes sense, appreciate the support of the community.
Help Article Resources
Check out the Formula Handbook template!