query function: need where format for multiple choice question in Google Forms

8 views
Skip to first unread message

Casey Smith

unread,
May 28, 2021, 9:31:16 AMMay 28
to Google Visualization API
I have people registering for events on one google form. in my response spreadsheet, i have the query function set to delineate which event (currently class 1 -5) each person has selected onto a separate tab .  However, if someone signs up for multiple classes (using the multiple choice question, how do i write the WHERE so that it sorts the same person's info into each of the class tab as requested?  Please understand i am new to this but pick up very quickly.
Reply all
Reply to author
Forward
0 new messages