My students and I all encountered this issue; most of them installed the tool just today during class, and on a variety of browsers, operating systems, personal/institutional accounts.
We tried to filter on one column (with "Copy all..." checked at the bottom), and the resulting formula in cell A1 of the new sheet was:
=QUERY('Form Responses 1'!A:O, "select A,B,C,D,E,F,G,I,J,K,L,O,O,O where G contains 'Yes'", 1)
This results in an error. (Cell A1 just says "#Value!")
This can be fixed by editing the cell text to correctly list the columns in alphabetical order:
=QUERY('Form Responses 1'!A:O, "select A,B,C,D,E,F,G,H,I,J,K,L,M,N,O where G contains 'Yes'", 1)
So I did two things... added the missing H, and changed "L,O,O,O" to "L,M,N,O" though just doing the second thing is enough to make it work. (But I guess column H would still be missing.)
Students encountered this "L,O,O,O" in their formulae no matter what column they filtered on later.
Interestingly, when a student tried to filter using the data that was actually in Column H, the formula also said "where O contains [whatever]" instead of "where H contains..."
My students and I all encountered this issue; most of them installed the tool just today during class, and on a variety of browsers, operating systems, personal/institutional accounts.
We tried to filter on one column (with "Copy all..." checked at the bottom), and the resulting formula in cell A1 of the new sheet was:
=QUERY('Form Responses 1'!A:O, "select A,B,C,D,E,F,G,I,J,K,L,O,O,O where G contains 'Yes'", 1)
This results in an error. (Cell A1 just says "#Value!")
This can be fixed by editing the cell text to correctly list the columns in alphabetical order:
=QUERY('Form Responses 1'!A:O, "select A,B,C,D,E,F,G,H,I,J,K,L,M,N,O where G contains 'Yes'", 1)
So I did two things... added the missing H, and changed "L,O,O,O" to "L,M,N,O" though just doing the second thing is enough to make it work. (But I guess column H would still be missing.)
Students encountered this "L,O,O,O" in their formulae no matter what column they filtered on later.
Interestingly, when a student tried to filter using the data that was actually in Column H, the formula also said "where O contains [whatever]" instead of "where H contains..."