I set up my Typeform with score logic, questions have been set up as multiple choice (there are 35) and i have assinged 1 point for correct answers and 0 points for incorrect answers.
In the export data i am able to see total score e.g. 26/35 but I am unable to see on a question by question basis what the score given was for that question... e.g. for question 16 I can’t see whether 0 or 1 points were assigned, only the text of the option selected.
Is there a workaround? Thx!
Answered
Am I able to export score per question data?
Best answer by john.desborough
you should add an other tab, call it “points version’, use the arrayformula() function to bring the data from the first tab in automatically and set up the logic in the spreadsheet to assign point value in an extra column you add that is based on conditional logic - something like “if (A6 = yes, 1, 0)
put that if statement inside the arrayformula() unction for that column and it will auto populate each time a record is added to the survey.
yes you need to take the time to set it up once, but then it runs like a dream
hope that helps
des
+5Hi
+6- Certified Partner & Champion
- 5259 replies
- Answer
you should add an other tab, call it “points version’, use the arrayformula() function to bring the data from the first tab in automatically and set up the logic in the spreadsheet to assign point value in an extra column you add that is based on conditional logic - something like “if (A6 = yes, 1, 0)
put that if statement inside the arrayformula() unction for that column and it will auto populate each time a record is added to the survey.
yes you need to take the time to set it up once, but then it runs like a dream
hope that helps
des
If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.