Google query function return data ranges's header when using "group by". The header includes property. Such as count, sum. You can use as below. =QUERY(F2:G4,"SELECT F, SUM(G) GROUP BY F

If you need to use google datevalue, timevalue functions in IFTTT, you should change settings. You can use arrayformula function without google script.

Google spreadsheets support query easily. If you use importrange, column position name was changed. That's time, you can use 'col#' notation. A is Col1, B is Col2 ........... Condition syntax rules are

frequently working schedule we need to view dates between startdate and enddate. [date type data] [formular] we can extract dates from working duration without adding any repeated codes. [script] function

IFTTT is good macro tool. But OccuredAt format is not compatible with google datetime. =TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) +