New answers tagged google-sheets-query
0
Instead of
date 'TODAY()'
use
date '"&TEXT(TODAY(), "yyyy-mm-dd")&"'"
NOTES:
The last " should be placed in a proper place in order to have a text value as the second argument of QUERY.
'TODAY()' doesn't returns Today's date, it returns a string with the word TODAY followed by parenthesis.
Try this
=ARRAYFORMULA(QUERY({A3:H, HOUR(A3:A)},
"...
2
That's a classic mistake when using Group By in a =QUERY
check this https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/
The GROUP BY clause is used with aggregate functions to summarize data into groups, in the same way a pivot table does. {...} Note, every column in the SELECT clause (i.e. before the GROUP BY) must either be aggregated (e....
0
The topmost answer's for REGEXREPLACE no longer works in current version of Sheets.
Here's what worked for me:
=REGEXREPLACE(A2;"(\d)"; "$1 ")
1
I think you're right that this is a date format issue.
On a quick look, when you test 27/07/2019 > 01/08/2019 the result is TRUE
However when 01/08/2019 > 5/08/2019 is tested you have the expected FALSE
When =DATEDIF(L8,L9,"d") is tested or Date A - Date B there's the expected 5 result.
So when I input the data myself (27/07/2019 > 01/08/2019) ...
1
Yes you can do it. There are a lot of approaches for this problem.
Example :
=QUERY(A:B,"SELECT * WHERE "&C1&C2")
Cell C1, C2 contains the rest of the query like
C1 B = 'Apples'
C2 OR B = 'Peaches'
You can build C1 and C2 with conditions such as
C1 =IF(D1<>"","B = '"&D1&"'","") Where D1 is your fruit's name
Then build ...
Top 50 recent answers are included
