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

Must install IFTTT in your android smart phone and join IFTTT. Must join google for spreadsheet. ▶️ DTube ▶️ IPFS

When you input daily or weekly data, you need copy & paste statistical(extracted) data, like below. For example, using google form and so on. Because Google forms data should be written at last row's

Google Calendar is good method for sharing schedule. Surely, user can input directly it. But manager needs another form. So, manager can receive members working list with date specific form. The specific

Google spreadsheet does not serve 'eval' function. User write custom function like: function myEval(s) { return eval( s) }​ But, it cannot use multi rows. If you want apply multi rows one time, you can

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

Someone needs customer cell phone numbers in files. Google spreadsheet is good file for saving cell phone numbers. If you use spreadsheet, you can send your data to cell phone using Zapier. (must join