'How can I get a list of which kids selected which options in a Google sheet result from a Checkbox grid form

I know this is very basic but I'm stumped - we have a checkbox grid form of 10 Post Prom Prizes that kids can choose up to 5 of. We will then randomly select the winner. What array or formula can I use to get a list of the student names that selected each prize? Should I use a different form format?

formsgoogle-sheets


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions