Stack Overflow
Stack Overflow

Questions tagged [google-query-language]

Google Query Language is the part of the Google Visualization API that lets the developer perform various data manipulations with the query to the data source. This could also be used in the Google Sheets QUERY built-in function.

Google Query Language allow developers to perform various data manipulations using a syntax very similar to the SQL syntax. It's part of the and can be used in through the QUERY built-in function.

Before posting a question about the Google Query Language check the reference documentation.

1114 questions
2
votes
1 answer

Google Sheet query all rows on today's date

I have a Google spreadsheet document with two sheets in it. The first sheet is where I want to run my query. Located in cell A1 is today's date with the formula =today(). I want the query to start in A2. My information is in the second sheet cells…
Stuart Sinclair
  • 21
  • 1
  • 2
2
votes
4 answers

converting Google Visualization Query result into javascript array

The url to the spreadsheet I am querying is docs.google.com/spreadsheets/d/1EIBhBQY1zbdBEKXsJIY1uyvdQw0b1cIBSrBE_tZvA6Y/edit?usp=sharing The query url being used…
George
  • 163
  • 1
  • 12
2
votes
2 answers

Google Sheets QUERY most recent unique entries

I am trying to use the QUERY function on a list of Google Form responses to only display the most recent of unique entries(based on the key Student ID). A = Timestamp Column C = Student ID Column Using: select max(A) group by C I was able to get…
Halfdane
  • 100
  • 1
  • 7
2
votes
1 answer

In Google Sheets, How Do You Order a Query by row

I am trying to make a query and drop it into a table (really only a 5x5 grid of boxes with a black border color), but I want it to be ordered by row instead of column. I currently have the formula =QUERY(B14:J14) and I tried to make it…
Josh Smith
  • 84
  • 1
  • 14
2
votes
1 answer

Calling a script function in a QUERY statement

In the QUERY "select" clause it states that you can use a scalar function in place of a column name, for example "year(A)". And in another part of the documentation it states that you can call a script function by coding "=function_name(...)" into…
just.a.guy
  • 192
  • 1
  • 2
  • 12
1
vote
1 answer

Filtering by multiple conditions, one condition has 2 desired values to filter by but returns all values or an error

So I'm trying to filter by a number of things (age, matching codes, a non-null DOB (not needed in this particular sheet as it's a subtraction and < operation on age, but I left it in for a following sheet that's basically the same formula &…
blob
  • 11
  • 2
1
vote
1 answer

Google Query Language seems to lack an equivalent to sql's "IN"

I know that match exists, but I need to run the equivalent of SELECT foo WHERE bar IN (SELECT baz WHERE qux='quux'). I have looked at the docuemtation and there is no mention of a way to do this, at least where I would expect it to be (see here). So…
Jacob
  • 135
  • 2
  • 12
1
vote
1 answer

How do I get text in a pivot table in excel or google sheets?

I have a list of data, that I have cleaned, but I need to organize it in a way that allows me to import it into a CRM. I can't think ov a way to convert that data into a decent table other than a pivot table. The problem is the pivot table doesn't…
Tim Cooley
  • 749
  • 4
  • 19
  • 38
1
vote
1 answer

How to apply array formula to join all the cells in a column and exclude empty cells in google sheets doc spreadsheet

=ArrayFormula(join(",",char(34)&E3:E11&char(34))) This is the formula I have thus far. It is able to output the values from the ranges I have manually chosen E3 to E11 which are Nurse Nurse Practitioner Physician Assistant Dialysis Nurse…
Vonkoff
  • 29
  • 2
1
vote
1 answer

Label giving error when using formulas within query statement/parameter in QUERY in Google Sheets

I have made much of what I wanted to work, but there's just one last thing. =QUERY(ALL!$A$4:$AB, "SELECT A, B, D, C, I, G, O, U, Y, U/I, C/U WHERE A is not null " &IF(OR(SUFIAN!$F$15="", SUFIAN!$F$16=""), "", " AND C >= "&SUFIAN!F15&" AND C <=…
Sufian Naeem
  • 15
  • 5
1
vote
2 answers

Excluding Data in Googlesheet

I have a set of data. There is a case where I have to exclude some data from the data set. Here is the sample case: https://docs.google.com/spreadsheets/d/1WbsNoUg9b29Hqex55H7fHqzW2rdgm2aAVgy-Y9DTa4Q/edit#gid=0 column A is the data set column C is…
Randy Adikara
  • 357
  • 3
  • 10
1
vote
1 answer

Imported data into Google Sheets, match and change one Column of Data

I have a google sheet that users input data on. These sheet has complete town names. Eventually the data they input gets uploaded into a program which has the town names abbreviated. Im looking for a way to automate basically doing find and…
Mr. Anderson
  • 55
  • 6
1
vote
1 answer

Using QUERY on Google Sheet returning "Formula parse error"

Writing a Google Sheet for personal expenses I am trying to create a query to sum the expenses of a type, but the editor is retrieving a parse error that I can't achieve the logs (not sure it is possible). Please consider only rows below row 15. On…
Augusto
  • 3,825
  • 9
  • 45
  • 93
1
vote
1 answer

Using a date in a cell in Sheet1 as a value for a filter in a Countifs formula for values in the date range on another sheet

I'm trying to use a formula in Google Sheets to use the date values of cells in Sheet1 (a27 and b27) as the Date references for the date range in the coutifs formula below. =countifs('Sheet2'!$C:$C,">=01/10/2023",…
Jasmin Kappert
  • 11
  • 2
1
vote
2 answers

How can you add more sheet tabs to existing IF/SumIF Google Sheet formula?

I'm trying to use Google's monthly budget template and alter it so I can get a full view of the year. I have tabs Jan-Dec made but I can't figure out how to add them to the below formula. When I try, it tells me that the IF can only use 3. The areas…
Brooke Taylor
  • 131
  • 2
  • 3
  • 11
1 2 3
…
74 75