This is the query code I'm using to get form responses filtered to pull only a specific user ID from a google form in one Google Sheets workbook into another workbook:
=QUERY(IMPORTRANGE("KEYID#","Form Responses!Col1:A"), "SELECT * WHERE 'Col12'=222")
The sheet has 12 columns, A:L. Rows keep getting added as new submissions are made.
I want to pull only row entries with the user ID 222. User IDs are located in Row E/Column 5. 222 is a number, not a string.
The query above returns a Value error:
"Error: Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: col12"
Without using IMPORTRANGE in the same workbook as the form database, I am able to query this using:
=QUERY('Form Responses'!A1:ABT,"where E=222")
Having two separate workbooks as intended, and I don't have the [select - where]
statement,
=QUERY(IMPORTRANGE("KEYID#","Form Responses!COL1:A"))
spits out the entire form database.
Any ideas?
Col12
instead ofCOL12
and is still wrongForm Responses!COL1:A
. The error is weird because in your formulaCOL12
is used notcol12
col12
and"Form Responses!Col1:A"
still generates the same error as I have above.Col1:A
isn't a valid reference in any casing combination. Don't use apostrophes to enclose column names.