Google Sheets QUERY IMPORTRANGE formula

1
votes

enter link description hereI'm trying to get a return of all Active jobs but I keep getting the error message #value!; "Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: A". Here is the formula I used.

=QUERY({IMPORTRANGE("SheetKey","employeeName1!A18:V1000"); IMPORTRANGE("SheetKey","employeeName2!A19:V1000");IMPORTRANGE("SheetKey","employeeName3!A19:V1000");IMPORTRANGE("SheetKey","employeeName4!A19:V1000")},"SELECT A, B, C, D, E WHERE E = 'Active'")

3
google-sheetsgoogle-sheets-formula
Please provide a sample sheet for replication of the issue. – Jason E.
I added a link in the comment – Mitchell Bivens
The sheet you've provided is inaccessible. – Jason E.
docs.google.com/spreadsheets/d/… – Mitchell Bivens
It should work now – Mitchell Bivens

3 Answers

2
votes

I tried replicating your issue by making a copy of your provided sample sheet but apparently, the formula works after making a copy of the sheet. Please see attached screenshot.

enter image description here

I suggest trying to copy it first making a new sheet with the same content and see if it will also solve your problem.

0
votes

use:

=QUERY({
 IMPORTRANGE("SheetKey", "employeeName1!A18:V1000"); 
 IMPORTRANGE("SheetKey", "employeeName2!A19:V1000");
 IMPORTRANGE("SheetKey", "employeeName3!A19:V1000");
 IMPORTRANGE("SheetKey", "employeeName4!A19:V1000")},
 "select Col1,Col2,Col3,Col4,Col5
  where Col5 = 'Active'")
0
votes

I took out the IMPORTRANGE and just used a query formula for the other sheets and it worked perfect. Thanks for the input everybody.