Merge Google Sheets into a single Master Sheet

0
votes

I am trying to merge and filter ranges (second their date) from different sheets into a master sheet. When using a single range it works but when adding a second range from a different sheet, like in this formula:

=QUERY({'Sheet1'!A3:I14 ; 'Sheet2'!A3:I14};"SELECT A, C, D, E, F, G, H, I WHERE (A >= date '" & text(today();"yyyy-MM-dd") & "' AND A <= date '" & text(today()+9;"yyyy-MM-dd") & "')"; false)

it gives the following error: Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: A.

What is the correct syntaxis to make the formula work?

2
arraysgoogle-sheetsgoogle-sheets-formulaarray-mergegoogle-query-language

2 Answers

1
votes

Instead of using A, B, C as field names use Col1, Col2, Col3

1
votes

use:

=QUERY({'Sheet1'!A3:I14; 'Sheet2'!A3:I14};
 "select Col1,Col3,Col4,Col5,Col6,Col7,Col8
  where Col1 >= date '"&TEXT(TODAY();   "yyyy-MM-dd")&"' 
    and Col1 <= date '"&TEXT(TODAY()+9; "yyyy-MM-dd")&"'"; 0)