CODEWITHSUNDEEP
google-sheetsgoogle-query-language
isk27
isk27

Reputation: 359

Always got Formula parse error when trying to use QUERY function on google sheet

I'm trying to select certain data from responses of a form on a google sheet. I just want to select all the data if one cell is equal to a specific word. I've created a new sheet inside the same archive, and tried with several formulas:

=QUERY("respuestas!A2:M50","select * where G = 'Felino'")

setting name range respuestas!A2:M50 = raw:

=QUERY(raw,"select * where G = 'Felino'")

importing range:

=QUERY(importrange("https://docs.google.com/spreadsheets/d/1y1WxrJ9ErkqX1gR5su37dAPe97fI9KZoeQtxhuSC2lA/edit","respuestas!A2:M50"),"select * where G = 'Felino'")

importing range with name range:

=QUERY(importrange("https://docs.google.com/spreadsheets/d/1y1WxrJ9ErkqX1gR5su37dAPe97fI9KZoeQtxhuSC2lA/edit","respuestas!A2:M50"),"select * where G = 'Felino'")

and trying with Col1 attribute instead Column name, like A2, in the select property. Also trying to select just a column like: 

"select A"

or

"select Col1""

and none of these works...

I dont know what else to try??

Upvotes: 5

Views: 5864

Answers (2)

logc
logc

Reputation: 3923

Depending on your locale, you might need to use a semicolon instead of a comma to separate arguments to the QUERY function.

This version was not working for me:

=QUERY(rows, "SELECT B, D")

While this version did work:

=QUERY(rows; "SELECT B, D")

Upvotes: 1

isk27
isk27

Reputation: 359

Ohh that works!!

Thanx...

It was just the semicolon... I've replaced ":" with ";"

Upvotes: 7

Related Questions