Sort responses from Google Forms into separate Google Sheets Tabs using this simple equation: =query('Form Responses 1'!A2:D,"Select * Where C='Mrs. Boucher'")
Great Video! Can you create an extra tab which would combine two answers i.e mrs Apple and Mrs Boucher? So you just have their responses (and not Ima Teacher)? If so, how would you change the formula?
This video is very helpful for what I'm trying to do right now. Is there any way you can type out the exact text of your formula? It is a little blurry in the video. Specifically, I can't tell what is between ('Form Responses and A2:D). Thank you!
Hi! Thank you for sharing this. It has been helpful for us in our office. I am wondering if you can help with formatting a little further. how do I need to write the formula if I want to filter two columns from the response sheet into the same sheet. For example, using the example in the video, if I wanted to filter the data by teacher AND by the timestamp into one tab. I have a larger google form and four of the questions on the form will need to be filtered into a new tab.
All those views and no gratitude. Thanks. Exactly what I needed today.
THANK YOU! Your equation just solved my problem! God bless you. Choose joy, Liz Jones (a teacher in Philly)
Thank you, this has saved and will save me so much time.
Excellent information ....I saw many videos but Iam not satisfied about the content on those videos ...I really liked ur video👌
Thank you so much 🙂
Excelent video and explanation.
Thank you so much for making it, I was looking for this since quite a while.
Great work.
Thanks for this! Can you please type the formula you used here? I cannot see it in the video and am trying to recreate what you did. Thanks!
=query('Form Responses 1'!A2:D,"Select * Where C='Mrs. Boucher'")
Great Video! Can you create an extra tab which would combine two answers i.e mrs Apple and Mrs Boucher? So you just have their responses (and not Ima Teacher)? If so, how would you change the formula?
Wow this is a game changer for gathering data for my students. Thanks
Glad it was helpful!
You are my best friend right now!!!!
Thanks for this video. It was informative and got me started in the right direction - Just in Time!
What if you want to have the Responses separated in tabs by the time stamp?
This video is very helpful for what I'm trying to do right now. Is there any way you can type out the exact text of your formula? It is a little blurry in the video. Specifically, I can't tell what is between ('Form Responses and A2:D). Thank you!
=query('Form Responses 1'!A2:D,"Select * Where C='Mrs. Boucher'")
where did you get the original formula from? How/where did you learn this?
Thank you very much Joli , that was very helpfull
Hi! Thank you for sharing this. It has been helpful for us in our office. I am wondering if you can help with formatting a little further. how do I need to write the formula if I want to filter two columns from the response sheet into the same sheet. For example, using the example in the video, if I wanted to filter the data by teacher AND by the timestamp into one tab. I have a larger google form and four of the questions on the form will need to be filtered into a new tab.
Super helpful, thank you for making this!
This was very helpful! Thank you!
Does this work in excel as well
Thank you! That was very helpful.
Brilliant! Thank you
THAT WAS USEFUL THANK YOOOOOOOOOOOOOOOOOOU
Thank you!
Thank you!!!
Thank you