google-query-language Questions
3
Solved
GAS is quite powerful and you could write a full fledged web-app using a Google Sheet as the DB back-end. There are many reasons not to do this but I figure in some cases it is okay.
I think the bi...
Noah asked 24/6, 2019 at 13:31
10
Solved
Consider the query run from sheet2
=query(Sheet!A7:A, "Select A,B,C where A='Order'")
but I want to put this in columns A,E,F in Sheet2.
I've found the workaround
=query(Sheet!A7:A, "Select A...
Halmstad asked 7/5, 2017 at 13:22
2
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 ar...
Saintsimonianism asked 14/10, 2017 at 3:13
3
Solved
I find one of the most useful aspects of Excel's new(-ish) Dynamic Arrays is that the # operator lets me refer to a range of cells where the number of rows is unknown (and liable to change). Is the...
Kilroy asked 13/7, 2021 at 20:31
9
Solved
I'm doing this query at my google spreadsheet:
=QUERY(H4:L35;"select sum(L) where H='First Week'"; -1)
But it returns a little table with "sum" as header and result below it. What I want is just...
Riplex asked 11/11, 2014 at 14:58
3
Solved
I have a Google Sheet with named ranges that extend beyond columns A-Z. The name ranges have header rows. I would like to use the QUERY function to select columns by their header labels.
My formula...
Pisarik asked 10/11, 2022 at 17:51
2
Solved
Is there a way to convert data going into a query() function so that blank/null values are converted to zero?
I have a dataset with three columns:
Group AC Plan
Comms 350 [blank]
IT 50,000 85,000...
Medrano asked 25/2, 2019 at 15:58
6
Solved
as per example:
A B C D E F G ∞
|======|=======|=====|=====|=====|=====|=====|=====
1 | |AVERAGE| | | | | |
|======|=======|=====|=====|=====|=====|=====|=====
2 | xx 1 | | 1 | 2 | 0.5 | 10 | |...
Yardman asked 24/12, 2020 at 7:33
1
Solved
I need to create a stacked column chart with Date aggregated on X-axis, and the bars with multiple (dynamically formed?) Category series.
All of the examples out there demonstrate how to create the...
Conjurer asked 18/4, 2022 at 10:52
1
Solved
I'm looking to extract the video title or video description from YouTube videos in Google Sheets. I have the URL and when I write the IMPORTXML formula, it keeps just showing me "Share your vi...
Irmgard asked 11/8, 2021 at 22:59
3
Solved
I have 2 tables and I am trying to perform a left join using google query language,or any formula that could output the result set.
Table1
Table2
Result set
How can I accomplish that ?
Regards
Twitt asked 18/12, 2020 at 21:0
2
Solved
I'm wondering how one might handle a query like this. Let's suppose I had the following text contained in Cell A2 of a spreadsheet:
Case Bakers' Flats 12" White Flour Tortillas 10/12ct
and neede...
Hyderabad asked 1/3, 2016 at 16:0
4
Solved
Here's my function:
=QUERY(QUERY(IMPORTRANGE("XXXXXXX", "XXXXXX!A1:C"),"SELECT * WHERE Col2 = 'Woman's blabla: blablabla'"),"SELECT Col1, Col2")
I've tried ...
Inurn asked 25/1, 2016 at 11:55
1
While removing the header row in a Google sheets query function seems straightforward, I don't see any suggestions on removing the header row when the query involves a pivot. For reference, I am gi...
Donatelli asked 18/8, 2020 at 12:26
1
Solved
I need to get the grouped median
I have grouped data of the form
From type Weight
A person-person 4
A person-person 3
A person-organization 11
A person-person 5
A person-organization 6
B person-per...
Guertin asked 28/7, 2020 at 15:32
6
Solved
This question is concerning joining two databases in Google spreadsheet using =QUERY function
I have a table like so in range A1:C3
a d g
b e h
c f i
I have another table
c j m
a k n
b l o
I...
Salta asked 10/2, 2013 at 10:8
1
Solved
I am trying to piece together a query that does a few things. One, I want it to list out all the names in a column, and two, I only want it to list out the name from that column if it doesn't exist...
Bovid asked 31/3, 2020 at 10:50
2
I want to import a range from another Google sheet, but to ignore empty cells so that the data prints back to back (versus having big gaps created from importing empty cells). Here is my formula (G...
Untwine asked 10/1, 2019 at 21:37
2
Solved
In Google Sheets, I want to filter view my results so only rows with an "x" in column D AND/OR column E are shown. If I filter to show the columns with an "x" in them, it will only show rows with a...
Frigidarium asked 9/11, 2017 at 16:44
1
Solved
I am trying to query results that don't contain #N/A results from another sheet in the same Google Sheets WorkSheet.
I have tried this formula but it won't work
=QUERY('Table 1'!A2:G500, "Select ...
Metamerism asked 13/6, 2019 at 22:5
2
Solved
The following line doesn't work:
=QUERY(AB:AE,"select AB,AC,AD,AE where AB NOT LIKE '%Info%'",1)
Throws:
Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encoun...
Roseroseann asked 11/5, 2019 at 18:47
4
Solved
Goal: I'm using QUERY() in gSheets to combine data from multiple sheets in the same workbook. The data is an extract from GA broken down into small segments to prevent sampling. This means it has a...
Aretino asked 11/1, 2017 at 0:34
6
Solved
I'm looking for a way to programmatically populate a spreadsheet that filters data from another spreadsheet based on the logged in user.
I am able to do this using the query function inside a spre...
Pitchstone asked 29/7, 2013 at 17:28
1
Solved
I am using Google sheets to record rental data. The table looks like this:
[Client Name] [Product Code] [Product Name] ... some irrelevant columns ... [Rental Start] [Rental End] [Rental Duration]...
Branchiopod asked 8/6, 2018 at 16:9
2
I am trying to create a simple query in my Google Sheet that will allow me to label the two columns it is outputting and sort the results based off of another column. However as soon as I add the O...
Hephzipa asked 24/10, 2017 at 14:6
1 Next >
© 2022 - 2024 — McMap. All rights reserved.