Sort Responses from Google Forms to Google Sheets Tabs

Sort Responses from Google Forms to Google Sheets Tabs

Joli Boucher

5 лет назад

90,500 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Jaskaram Kaur Khalsa
Jaskaram Kaur Khalsa - 01.05.2021 00:45

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.

Ответить
Kate Swank
Kate Swank - 26.04.2021 23:49

Does this work in excel as well

Ответить
Heather Freeman
Heather Freeman - 18.04.2021 09:16

You are my best friend right now!!!!

Ответить
EILEEN PEACHEY
EILEEN PEACHEY - 14.09.2020 18:27

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!

Ответить
Poovandrie Jansen
Poovandrie Jansen - 07.09.2020 19:34

Wow this is a game changer for gathering data for my students. Thanks

Ответить
mutyala archana
mutyala archana - 13.08.2020 19:48

Excellent information ....I saw many videos but Iam not satisfied about the content on those videos ...I really liked ur video👌

Ответить
Edwin Fernández
Edwin Fernández - 28.07.2020 01:23

Excelent video and explanation.
Thank you so much for making it, I was looking for this since quite a while.
Great work.

Ответить
Steffy47
Steffy47 - 18.07.2020 07:00

Super helpful, thank you for making this!

Ответить
jino
jino - 09.07.2020 16:35

Thank you!

Ответить
ailene catambay
ailene catambay - 30.05.2020 18:14

Thank you

Ответить
Gary Thomas
Gary Thomas - 29.05.2020 09:41

All those views and no gratitude. Thanks. Exactly what I needed today.

Ответить
Bill White
Bill White - 09.05.2020 03:14

Thank you, this has saved and will save me so much time.

Ответить
Frank Zintl
Frank Zintl - 17.04.2020 04:08

Thank you!!!

Ответить
Jonathan Young
Jonathan Young - 13.04.2020 19:54

where did you get the original formula from? How/where did you learn this?

Ответить
فاطمة المهدي
فاطمة المهدي - 13.04.2020 12:33

THAT WAS USEFUL THANK YOOOOOOOOOOOOOOOOOOU

Ответить
Liz Jones
Liz Jones - 08.04.2020 16:16

THANK YOU! Your equation just solved my problem! God bless you. Choose joy, Liz Jones (a teacher in Philly)

Ответить
Roger Kopa
Roger Kopa - 01.04.2020 05:25

Thank you! That was very helpful.

Ответить
Richard Kord
Richard Kord - 13.03.2020 23:28

This was very helpful! Thank you!

Ответить
Owain Binding
Owain Binding - 03.12.2019 18:39

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?

Ответить
Mekentichi Med.E
Mekentichi Med.E - 20.11.2019 14:56

Thank you very much Joli , that was very helpfull

Ответить
Ruth McKeachnie
Ruth McKeachnie - 29.10.2019 21:24

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!

Ответить
Deb Boisvert
Deb Boisvert - 30.09.2019 17:37

Thanks for this video. It was informative and got me started in the right direction - Just in Time!

Ответить
Alex Pope
Alex Pope - 02.09.2019 13:35

Brilliant! Thank you

Ответить
J McNeilly
J McNeilly - 27.07.2019 19:22

What if you want to have the Responses separated in tabs by the time stamp?

Ответить