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,
spits out the entire form database.
COL12and is still wrong
Form Responses!COL1:A. The error is weird because in your formula
COL12is used not
"Form Responses!Col1:A"still generates the same error as I have above.
Col1:Aisn't a valid reference in any casing combination. Don't use apostrophes to enclose column names.