Good afternoon!
I have a typeform that collects responses and sends these responses to a Google spreadsheet but the questions/responses are not in the same order as they appear on the typeform. How do I fix this?
I’ve tried fixing this by moving the columns around but this breaks the mapping of the questions/responses and duplicates them.
Please let me know!
Best answer by john.desborough
View original
+6
des
+5
Hi 
I have the same issue. The data in my google sheet appears to be in random order. Almost useless. I wonder how anybody can use this mess? I am new to the community. How does this get fixed?
Thank you
+6
if you create some questions, make the connection and then go back and add questions and move them around, and then publish the form, you run the risk of ‘seemingly random’ field structure.
Again, you might find it easier to make a second tab in the sheet, call it whatever you want, and put in short column headers (as opposed the actual text of the question), and then use the arrayformula function to pull the data from the primary tab into this second tab in the field order that makes sense to you
des
I couldn’t figure out the “arrayformula” in this case but a simple “=” and cell reference worked. Thank you.
+6
the image below shows a screenshot of using the arrayformula to pull in the column of the email addresses in a ‘simple’ pull - you can see it in the formula block
here’s a little more complicated one from the same sheet that grabs the data from another tab based on using a vlookup of the email address in column A.
just in case that helps understand it a bit better..
cheers
des
Thanks, that helped. Its very simple and effective!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
