I want to make conditional questions in my app. Meaning if someone answers โYesโ to question 1, an extra question (lets call it 1.5) would come up as a result that wouldnโt otherwise be there.
For example:
1.) Do you have a dog? Yes or No (User selects Yes)
1.5) What kind of dog do you have? (This question shouldnโt appear on the app if they answered no to the previous question)
2.) Do you have a cat? Yes or No (User selects No)
3.) Do you have a different kind of pet? (User selects Yes)
3.5.) What kind of pet do you have?
Iโm working with Microsoft Excel as my source of the data.
Youโll want to use the โshowifโ field in your column structure.
Letโs assume question 1 column header is called โdogโ and question 1.5 column header is called โdog type,โ the showif formula for your โdog typeโ column would be: [dog]=โyesโ
I edited the above reply - added a bit more detail.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |