AnsweredAssumed Answered

Creating a section to summarize total choices

Question asked by on Mar 30, 2019
Latest reply on Apr 1, 2019 by

Hello everyone!


I have a predicament with a survey form I am developing.


We're doing very detailed reef substrate checking.  We have 4 segments (which I conveniently separated into groups in this survey). Each groups have 20 intervals, thus containing 20 select_one questions. And each question ('select_one' question) has 10 choices of answers! Just explaining this is already scaring me a little. 


I am wondering if there is a possible way to calculate and sum the different choices accordingly at the end of the survey in a 'note' question type?


I've gone through some of the answers here, and I found something like the formula below:


if(selected(${question1}, 'yes'), 1, 0) + if(selected(${question2}, 'yes'), 1, 0) + if(selected(${question3}, 'yes'), 1, 0)


I am not sure which 'column' I'm supposed to type this into and typing out 20 questions times 4 isn't too practical! How do we go about this?



Any sort of input/hints would be super awesome and will really help us out. 





xlsform survey123forarcgisconnect geonet survey123