All Questions
Tagged with google-query-language google-sheets-formula
604 questions
0
votes
2
answers
97
views
Cannot use WHERE together with other formatting options
I'm using Google Sheet's QUERY function to import data from another tab, add two additional column 'Year' and 'Month' which are generated using column H
=QUERY(earnings!A:J, "SELECT A, B, C, YEAR(...
- 981
0
votes
2
answers
79
views
Google Sheets Query - using another query to filter dates
I have the following datasource in a GoogleSheet:
DATE
PROJECTED
BALANCE
01/01/2025
FALSE
$3,824.54
01/16/2025
FALSE
$2,366.39
01/21/2025
FALSE
$3,783.64
01/22/2025
TRUE
$3,750.72
01/28/2025
TRUE
$3,...
-1
votes
2
answers
58
views
Query call via Apps Script returning 0 (zero) instead of Data Range
For some reason, historyQuery2 returns the proper data range, but historyQuery1 returns 0.
function getEventHistory(cS,findAcct) {
// copy filtered values from Events sheet to Client sheet (cS)
var ...
0
votes
1
answer
43
views
Odd QUERY result in Google sheets?
I have a very simple query function in Google sheets, and I cannot understand why I'm getting the result it produces.
=QUERY(A4:C,"SELECT B WHERE A='Active' ")
It returns the data properly, ...
- 115
1
vote
3
answers
98
views
How do I do basic date grouping operations in Google Sheets?
I have data that looks like this (sample):
Col A
Col B
Col C
Value 1
Value 2
1/4/24 4:15 pm
Value 3
Value 4
1/4/24 6:30 pm
Value 5
Value 6
1/5/24 2:30 pm
Value 7
Value 8
1/5/24 3:30 pm
Value 9
Value ...
- 819
1
vote
4
answers
91
views
How to use date with LIKE inside query?
I've got a google form(which feeds to Google sheets) for users to enter information. One of the fields is a datepicker which has this format mm/dd/yyyy.
I have a workbook with several sheets. One ...
- 43
-1
votes
1
answer
97
views
Google Sheet Query - Language
Good day! I hope someone can assist me. I'm having an issue with my B6 cell (Morning Shift time),
I think (if I'm correct) this line has a problem but i just can't figure out what's wrong with it.
IF(...
-3
votes
2
answers
64
views
How to stack 2 query results (Top/Bottom) where the queries may give no results? [closed]
How to stack 2 query results (Top/Bottom) where the queries may give no results?
I try to describe my problem clearly.
I am now using the formula "={query(....); query(....)}" to stack two ...
- 21
0
votes
0
answers
54
views
Formula to look at one sheet and find the match on another sheet
I have a Google Sheet that I want to update another Google sheet when it finds a match. In the sheet, I have a tab named 'Master Sheet', a data entry sheet with multiple entries with the same data as ...
- 15
0
votes
1
answer
129
views
Query formula not grouping properly
I have a google sheet where one tab is the data entry sheet named "
Master Sheet". and I have another tab labeled "Charts/Tables". On the second tab I have a query pulling data ...
- 15
0
votes
3
answers
89
views
Why does my Google Sheets query simplificaiton result in an error?
I have a Google sheet question. I use a formula to sum all values of a column that contains keywords in an other column. I use this formula :
=QUERY(Data!A1:I; "SELECT SUM(G) WHERE (LOWER(B) ...
- 13
0
votes
1
answer
110
views
How to generate a table with main categories and subcategories with blank rows in Google Sheets
I'm working on a Google Sheets project where I need to generate a summary table from a dataset. The dataset includes columns for categories and subcategories, and I want to create a new table where:
...
- 29
1
vote
2
answers
560
views
Need to make a Query in Google Sheets from a multiple dropdown list into a cell containing coma separated values
I've got a Google Sheet with data (Columns A,B,C), a dropdown list (E) and source for this dropdown list (G)
https://docs.google.com/spreadsheets/d/1XY5Nfwi-DtXIV7PMkhax_60EpX5puawmUF-fl2qvEqk/edit?...
- 43
-1
votes
2
answers
587
views
Compare 2 columns using QUERY function in Google Sheets
I'm comparing 2 columns, where some values are missing from column B (1st column).
Can you please help me how to use =QUERY function to return missing values?
I know that I can use =FILTER, =MATCH, ...
0
votes
0
answers
33
views
How to avoid sorting when query?
A food name will be shown on col 'First meal' when a checkbox is checked, but it is auto sort if multiple checkbox are checked.
I use =QUERY(A3:B5,"select A where B=TRUE label A 'First meal'"...
- 1