I'm working with Google Spreadsheets and I've run into a wall with a query(IMPORTRANGE)
function:
=Query((IMPORTRANGE("URL","Sheet Name!A2:P1000"),"select Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8,Col9,Col10,Col11,Col12,Col13,Col14,Col15,Col16 WHERE Col6 contains 'Abstract & TO'",16))
I keep getting a "Formula Parse Error".
Any suggestions on how to resolve the problem?
Best Answer
You probably want 1 instead of 16 as the last parameter of the query; this parameter means the number of header rows, not of headers.
You also have an extra pair of parentheses in your formula. Otherwise the formula is correct (tested in my spreadsheet), although you could shorten it by replacing
select Col1,Col2,..., Col16
withselect *
A possible source of your errors is that your spreadsheets are not connected for the purpose of
IMPORTRANGE
:Unfortunately, you will not see this prompt if your
IMPORTRANGE
command is within aQUERY
; the parse error is thrown instead as there is nothing forQUERY
to parse. To connect the spreadsheet, import something first, e.g.,You will see
#REF
error; hovering over it shows an explanation and "connect" button.