Splitting Multiple Choice (Checkboxes) Responses from Google Forms into Choice-Specific Columns

Описание к видео Splitting Multiple Choice (Checkboxes) Responses from Google Forms into Choice-Specific Columns

Skip right to the formula if you're already familiar with the Checkbox question in Google forms 6:33
Kaisyn's first video! We're a recent start-up that focuses on helping NGOs and students in the social sciences and education domain go digital. Read more about us in our "About" Section.
A lot of us may be including questions requiring multiple choice selections, otherwise known as Checkbox questions in Google forms. Unlike most other platforms, Google Forms currently (as of December 2021) doesn't give the ability to split multiple choices into separate columns. A lot of the answers out there involve using complex methods, formulas or just don't give the solution of separating the selected choices into specific columns.
In this video, we show a simple method involving only three steps to achieve the separation the way it is wanted.
The video shows both the often-followed path of using Text-to-columns and highlights its drawbacks, and the simple three-step method. If you're in a hurry, skip right to the formula part: 6:33

So let us know if this video helped you and what languages you'd want to see this solution in, and what other topics you'd like to learn from us.
We love feedback too!

Комментарии

Информация по комментариям в разработке