Categorize Google FORMS responses in different sheets in Google SHEETS

In this tip, we will learn how to send your Google Form responses to different sheets depending on the answer
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheet...
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheet...
➤Webpage: practicalsheet...
➤Newsletter: practicalsheet...
➤Telegram: practicalsheet...
➤Facebook: practicalsheet...
➤Twitter: practicalsheet...
Any suggestion, question or insights, feel free to comment below

[@tanakornpromthep9025]

Thanks for sharing

[@practicalsheets]

Thanks for commenting!

[@user-tr9xh9gc2n]

Hi, how to create a google form which automatically separate the responses into a different spreadsheet (different google sheet files) by work unit category (from the multiple choice google form question) when respondents answer the questions / enter the data in the google form.

[@riddhidoshi9110]

This was so helpful!

[@practicalsheets]

Thank you!

[@AimeeBottorffBelovedPearl]

I appreciate your video! I am wondering what would change in the Apps Script if my Google form has 5 questions and the 4th question is the multiple choice? Thank you!

[@practicalsheets]

Hello!
This is the important line
let city = responseSheet.getRange(rowToCopy, 4).getValue()
make sure that "4" matches to the column where the response of your dropdown arrives
Kind Regards

[@AimeeBottorffBelovedPearl]

@@practicalsheets Thank you, have a great day!

[@SamsonTennela]

This is aweome. Thank you!

[@user-lk8dr4nq1y]

Is there a way to only have the categorized sheets and not the master responses sheet or is the only option to hide it?

[@practicalsheets]

You could do everything with Google Apps Script
Kind Regards

[@krpdi3m]

Super useful!
If I want this to work alongside with the ID Ref script what should I do?
Tried copying ID REF code to be before Categorize Code, but could make it work; I changed column values to be +1 and to try to copy the last column but couldn't make it.
Even if it's not possible this still works a lot!

[@practicalsheets]

It depends. Would you like to have the consecutive independent for each category? This will be a bit trickire, but both ways could be done
Kind Regards

[@krpdi3m]

@@practicalsheets No, just copy the Master Consecutive ID. I copied the consecutive code and paste it before the categorize responses, then added a +1 to columns= rangeToCopy.getNumColumns()+1, but I think I may be doing this wrong or understanding it wrong.
Thanks for all your help! will keep watching your videos to keep learning

[@krpdi3m]

I did some more testing: tried working with two different functions on same code but couldn't get it to work.
So what I did was create just one "new" function which has both codes, and at the end of my "new" function, paste the value stored in "consecutive" (from the other video).

[@practicalsheets]

@@krpdi3m Excellent!

[@safwanahothman6636]

hi! i followed accordingly however my google sheet does not have the function =query

[@practicalsheets]

Hello!
Are you sure you are not working with an excel file?
Kind Regards

[@stugreenhouse6680]

I get all the data from the first column in the first cell. I.e A1:A500 in now all inside A1. Where am i going wrong here

[@practicalsheets]

Could you show me your code pls?
Kind Regards

[@diegopatt]

It also doesn't work for me

[@bestdealjor2211]

not working for me , can u please help ?

[@vonswelllathan2154]

Hello can I get a copy of this script?

[@practicalsheets]

Yes of course. You may go to the Patreon page where you can downoload the whole file with the script
Anything you may need please let me know
Kind Regards

[@michellebeatty8079]

Mine seems to be formatted just like yours but it gives an error.
=QUERY('Form Responses 1'!B:L, "SELECT B:L WHERE L='8th Grade'")
Any clue why the error?

[@thedude2000zify]

Hey try to write all column names, and separate them with commas and then see? For instance "SELECT B,C,D,E,F,G,H,I,J,K,L WHERE L='8th Grade'"
See if that resolves the issue.

[@CutTiesWithYourCaptor]

Instead of SELECT B:L use SELECT *
The * tells it to select all.
=QUERY('Form Responses 1'!B:L, "SELECT * WHERE L='8th Grade'")

[@michellebeatty8079]

@@thedude2000zify thank you

[@michellebeatty8079]

@@CutTiesWithYourCaptor thank you

[@practicalsheets]

Couldn´t have answered it better. Thank you!

[@TaiKneeDancer]

This was so helpful!

[@practicalsheets]

Thanks so much!