multiple if statements to get answer from previous question

choenig — Thu, 08 Feb 2024 21:43:35 GMT

I am creating a survey that asks the user a question, then based on that answer, a new question is created. I have that part figured out, but I want to have a text field at the end that confirms the answer the user ended up at. I have tried nesting my if statements, but I keep getting an error back.

In the attached image, see the Rank calculation, also listed here: if(${Q3}='3a','Rank 1',if(${Q4}='4a','Rank2,if(${Q5}='5a','Rank 3',if(${Q6}='6a','Rank 4',if(${Q7}='7a','Rank 5','')))))

Is it something with how I have my calculation set up or how my choice filter is set up for the questions prior? I'm getting super frustrated so it's hard to see straight, now!

Thanks

@IsmaelChivite

Re: multiple if statements to get answer from previous question

DougBrowning — Thu, 08 Feb 2024 21:36:01 GMT

Looks like you are just missing a quote

if(${Q3}='3a','Rank 1',if(${Q4}='4a','Rank2*missing right here,if(${Q5}='5a','Rank 3',if(${Q6}='6a','Rank 4',if(${Q7}='7a','Rank 5','')))))

topic multiple if statements to get answer from previous question in ArcGIS Survey123 Questions

multiple if statements to get answer from previous question

Re: multiple if statements to get answer from previous question