New answers tagged

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