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
practicalsheets.com/patreon
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: practicalsheets.com/patreon
➤Webpage: practicalsheets.com
➤Newsletter: practicalsheets.com/newsletter
➤Telegram: practicalsheets.com/telegram
➤Facebook: practicalsheets.com/facebook
➤Twitter: practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below

[@SamsonTennela]

This is aweome. Thank you!

[@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.

[@TaiKneeDancer]

This was so helpful!

[@practicalsheets]

Thanks so much!

[@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!

[@diegopatt]

It also doesn't work for me

[@bestdealjor2211]

not working for me , can u please help ?

[@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