Community
Select to view content in your preferred language

Question About Calculations in Survey123

375
1
07-31-2023 12:23 PM
JuliaChrisco
by
New Contributor
‎07-31-2023 12:23 PM

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.

 

0 Kudos
1 Reply
abureaux
by MVP Frequent Contributor
MVP Frequent Contributor
‎08-01-2023 08:41 AM

abureaux_0-1690904432226.png

example1 provides a single result.

example2 shows how to do a nested result.

Edit. Sorry. Saw the word "Connect" in your last sentence... Not a big user of web interface since it is just too limiting. If you are going to be using S123 a lot, Connect is quite easy to get into.