Clever Geek Handbook

Google Doc Query works on one sheet but gives parsing error on another sheet

I have a google doc request that works on one table. But when I duplicate the spreadsheet, the request does not work, and I get an error parsing: Unable to parse query string for Function QUERY parameter 2: NO_COLUMNCol2

.

My request looks like this:

=QUERY(importRange("sheetID‬", "Transactions!A1:Z200"), "select Col1, Col2, Col3, Col4 where Col2='Room Booking'")

I tried to change the request to:

=QUERY(importRange("sheetID‬", "Transactions!A1:Z200"), "select A, B, C, D where B='Room Booking'")

but get error: Unable to parse query string for Function QUERY parameter 2: NO_COLUMNA

Thanks for any contribution to this.

+3


source to share


2 answers


In new Google spreadsheets, IMPORTRANGE requires the entire url to be like spreadsheet_key.



+1


source


Thanks for this! Also, () I didn't know there was a new and old version of Google Spreadsheets. The formula worked on my old sheets, but not on the new sheets. (After some luck figuring this out.) The new version requires IMPORTRANGE to be "connected" to the sheet before it actually imports the data.



+1


source






More articles:


All Articles