=QUERY(FormResponses01!A:RW,"select C, E,I,U,V,X,Y,Z,AB,AC,AD,AF,AG,AH,AJ,AK,AL,AN,AO,AP,AR,AS,AT,AV,AW,AX,AZ,BA,BB,BD,BE,BF,BH,BI,BJ,BL,BM,BN,BP,BQ,BR,BT,BU,BV,BX,`BY`,BZ,CB,CN,CR,CQ,CY,DC,DB,DJ,DN,DM,DU,DY,DX,EF,EJ,EI,EQ,EU,ET,FB,FF,FE,FM,FQ,FP,FX,GB,GA,GI,GM,GL,GT,GX,GW,HE,HI,HH,HP,HT,HS,IA,IE,ID,IX,IY,JA,JB,JC,JE,JF,JG,JI,JJ,JK,JM,JN,JO,JQ,JR,JS,JU,JV,JW,JY,JZ,KA,KC,KD,KE,KG,KH,KI,KK,KL,KM,KO,KP,KQ,KS,KT,KU,KW,KY,KZ,LA,LC,LD,LE,LN,LR,LQ,LY,MC,MB,MJ,MN,MM,MU,MY,MX,NF,NJ,NI,NQ,NU,NT,OB,OF,OE,OM,OQ,OP,OX,PA,OZ,PI,PM,PL,PT,PX,PW,QE,QI,QH,QP,QT,QS,RA,RE,RD where C = date '2019-11-02' order by E ASC")
I've seem to discover that any columns pass JO causes the query to go weird. Is there a limit?
Bookmarks