multiple if statements to get answer from previous question

237
1
Jump to solution
02-08-2024 01:33 PM
choenig
New Contributor II

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 

 

0 Kudos
1 Solution

Accepted Solutions
DougBrowning
MVP Esteemed Contributor

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','')))))

View solution in original post

0 Kudos
1 Reply
DougBrowning
MVP Esteemed Contributor

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','')))))

0 Kudos