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

Question

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??

What is your locale? Have you tried ; instead of , between your parameters? — Aurielle Perlmann
– Aurielle Perlmann, Commented Oct 14, 2017 at 3:17
The first one should be =QUERY(respuestas!A2:M50, "select * where G = 'Felino'"), no quotation mark around the range. The importrange version can only work with Col1. But if no query work at all, maybe indeed you switched the locale and need to use semicolons for separating arguments. — user6655984
– user6655984, Commented Oct 14, 2017 at 3:18

isk27 · Accepted Answer · 2017-10-14 03:29:57Z

7

Ohh that works!!

Thanx...

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

answered Oct 14, 2017 at 3:29

isk27

3592 gold badges5 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

logc · Accepted Answer · 2024-01-07 14:09:01Z

1

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

answered Jan 7, 2024 at 14:09

logc

3,9331 gold badge20 silver badges30 bronze badges

1 Comment

logc Over a year ago

The answer from @AuriellePerlmann solved it for me, too, but since it is in a comment, and the accepted answer from OP mentions a replacement that is not what worked for me, I have put my solution in a separate answer ... Thanks to both!

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related