Questions tagged as 'google-query-language'

I'm making a query for the google spreadsheet and it's giving me a bug in the last part of it. The query works with 3 data that are inserted by validation in boxes B1, D1 and B2. This is what I have: =if(AND(B1=0;B2=0;D1=0);IMPORTRANGE(...

I'm doing a query for the google spreadsheet, but when in the where I indicated a cell of the sheet, I get an error. The query I have is: =query(IMPORTRANGE("enlace"; "Llista!A6:S1000");"select * where Col6='"B1"' and Col8='"B2"'") I ha...