Hello, I am new to Typeform. I have a likert scale survey, with a 1-5 range. In the typeform, I have assigned a numerical score per text answer. However, when I export a CSV report, and then kick it into Sheets, I notice that answers are still in text, not in a numerical value. Is it possible to generate a report that includes the numerical result for each selected answer (per submission, per question)? Otherwise, I will have to do it in Sheets. Thank you, Nicole
Answered
Export score per question per submission
Best answer by john.desborough
if you are using logic rules to assign point values to each, in order to come up with a total score or subcategory totals, you will have to look at the variables.
typically csv extracts are strings and it is the import tool that does the conversion based on any metadata that is available.. otherwise you will need to convert the numeric-looking text field into a number field.
des
+5Hi
Life is a series of awkward moments separated by snacks.
+2does every answer stay behind in the sheets or only a few?
+6- Certified Partner & Champion
- 5300 replies
- Answer
if you are using logic rules to assign point values to each, in order to come up with a total score or subcategory totals, you will have to look at the variables.
typically csv extracts are strings and it is the import tool that does the conversion based on any metadata that is available.. otherwise you will need to convert the numeric-looking text field into a number field.
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.