I created a survey in Survey123 web designer, and I'm wondering if there's a way to calculate an output into a column of the data table that uses the answer to multiple questions. I've given it several attempts and so far have come up with nothing.
For example, I have 3 single-choice questions that are Yes/No answers, and survey-takers will be sorted into different groups based on their responses. Is there a way to have a calculation that states, if Q1 = yes and Q2 = yes and Q3 = yes, then mark as Group 1. If Q1 = yes and Q2 = yes and Q3 = no, then mark as Group 2.
I know I can manually just filter the data, but I'm trying to find a way to streamline things a bit more. I'm sure this is easily accomplished in Connect, but as of right now we're trying to stay within the web designer.
