CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Mitchell Bivens
Mitchell Bivens

Reputation: 99

Google Sheets QUERY IMPORTRANGE formula

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'")

Upvotes: 1

Views: 370

Answers (3)

Mitchell Bivens
Mitchell Bivens

Reputation: 99

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

Upvotes: 0

Jason E.
Jason E.

Reputation: 1221

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.

Upvotes: 2

player0
player0

Reputation: 1

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'")

Upvotes: 1

Related Questions