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
1
vote
1 answer

How to have this formatted data return empty given this is VLOOKUP + TEXT + QUERY in Google Sheets?

This is the formula, currently. It outputs 12/30/1899, but it actually returns 0 and since TEXT() is forcing it into a data, this is how it shows. How to have this ARRAYFORMULA() populate the values and empty when there is no…
onit
  • 2,275
  • 11
  • 25
1
vote
1 answer

How to avoid this empty row using QUERY() in Google Sheets?

I've tried applying some criteria, but the row is still there. This first empty row shouldn't be there. Here is the formula, in case you'd like to help me correct it: =if(I4<>"", { IFERROR(query(Datasets!X3:AU,"select AS, AT, AJ, AR where AS matches…
onit
  • 2,275
  • 11
  • 25
1
vote
1 answer

Error Query, and xlookup formula in dropdown list

Someone in this group had created a google sheet file for me. and I have given some names in the list in that google sheet files. Can you prepare the appropriate code to get the result through that given name? The person who made this cannot be…
ACHU
  • 17
  • 3
1
vote
2 answers

ARRAY_LITERAL error when Query Array Function stacking multiple google form responses

So I have a unique problem. I have a Google form used for site inspections that allows up to 25 "issues" to be entered per Form submission. As normal, when submitted the issues are recorded in a single row in the spreadsheet. To more easily be able…
J.Raab
  • 87
  • 7
1
vote
2 answers

Google Sheets "=QUERY()" JOIN ON or equitant

I have one large spreadsheet with names, addresses, phone numbers, emails, Etc. Some records have a second address for which I have a column named "Address 2" I was hopping to write a query that would give me an output with duplicate rows of which…
Paradise Promotions
  • 13
  • 3
1
vote
2 answers

query: Remove aggregate function name for header

I have simulated joining in google sheets with one =query function per row. If I put an aggregate function in there, this does not work anymore, since I'll always get two rows at least: 1 for displaying what aggegate function I have, one displaying…
Frischling
  • 2,100
  • 14
  • 34
1
vote
1 answer

Google Sheet query where literal string contains field value

Let's say you have a table of properties in a Google Sheet... Col A (Name) Property 1 Property 2 Property 3 Property 4 Property 5 ... and you want a formula-driven solution that pulls data on certain properties, specified by a…
Steven
  • 13
  • 3
1
vote
1 answer

Workaround Argument must be a range error when using SUMIF + FILTER

Col A Col B Col C a back 1 a back 1 b b draw 1 c back 1 c d draw 1 d draw 1 e draw 1 In Column E I put the values from Column A using UNIQUE and sorting with SORT: =SORT(UNIQUE(A:A)) In Column F I tried to put a…
Digital Farmer
  • 1,705
  • 5
  • 17
  • 67
1
vote
2 answers

Showing Top 5 Clients at a dashboard

I want to build a dashboard where I can select a year and a application and want to have the top 5 clients shown up. I build a example Sheet ofr…
Weser
  • 59
  • 4
1
vote
1 answer

Calculate the average of sets of cells satisfying a certain criterion (AVERAGEIF)

This is my Items sheet And this is my Values sheet As can be seen from the table, alfa is associated with 20 40 60 80, beta with 30 40 70 80 and gamma with 50 60 70 80. In the Items sheet in cell B1 (next to the first item) I would like a formula…
G. Lari
  • 435
  • 2
  • 14
1
vote
1 answer

Google Sheets - Is it possible to use query to search for the data from the sheets that i select with dropdown list? If not, what can i do?

GoodDay everyone, recently I am trying to learn about using the Google Sheets. My question is same as the title, and these are some examples of the data. The data from first sheet The data from second sheet I am trying to create a searching function…
Jackie6333
  • 15
  • 2
1
vote
1 answer

Label Column with Query that references multiple sheets in Google Sheets

using the below script to "append" data from multiple sheets on to one and it works but I need for it to add the sheet name where the data comes from in Column 28 and when I add label Col28 'sheet name' to the end of the SQL syntax, it triggers an…
Sam R.
  • 27
  • 5
1
vote
1 answer

How can I format a string sheet to date with Query

I have a col on googlesheet, that I need convert to date time with query function. Column A Column B nome1 2022-11-17T13:41:47.431Z name2 2022-11-17T13:41:47.431Z Column A Column B nome1 2022-11-17 13:41:47 name2 2022-11-17…
Bruno - Growth Sales
  • 15
  • 3
1
vote
2 answers

Counting unique elements in a table

I have a table with names of players like this: Player John Eric Valerie Carmen And another table with a list of played matches (match number, match date and the list of players that played in the match). Something like…
G. Lari
  • 435
  • 2
  • 14
1
vote
2 answers

List non-unique entries and their counts sorted in descending order

If I have a list of names in a sheet for example: First Name|Last Name|Something else| Maria|Miller|...| John|Doe|...| Maria|Smith|...| Marc|Meier|...| Marc|Park|...| Maria|Muster|...| Selene|Mills|...| Adam|Broker|...| And then I want a second…
kumoyadori
  • 337
  • 2
  • 10
  • 21
1 2 3
…
74 75