BlogHide Resteemszero6pak (25)in spreadsheet • 6 years agogoogle query label replacement when using "group by"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 LABEL…zero6pak (25)in spreadsheet • 6 years agoDate Time Replacement In IFTTT with settings and functionsIf you need to use google datevalue, timevalue functions in IFTTT, you should change settings. You can use arrayformula function without google script.…zero6pak (25)in spreadsheet • 6 years agousing query function with importrangeGoogle 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…zero6pak (25)in spreadsheet • 6 years agoEnumeration of dates between 'startdate' and 'enddate' using Custom functionfrequently 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…zero6pak (25)in dtube • 7 years agoManaging working time using IFFTT (Location based)Must install IFTTT in your android smart phone and join IFTTT. Must join google for spreadsheet. ▶️ DTube ▶️ IPFSzero6pak (25)in arrayformula • 7 years agoMy favorite function ARRAYFORMULA in Google SpreadsheetWhen 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…zero6pak (25)in spreadsheet • 7 years agoGoogle Spreadsheet to Google Calendar using ZapierGoogle 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.…zero6pak (25)in eval • 7 years agoeval function in google spreadsheet; multi rowsGoogle 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…zero6pak (25)in spreadsheet • 7 years agoDate Time Replacement In IFTTT with google scriptIFTTT is good macro tool. But OccuredAt format is not compatible with google datetime. =TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) + DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))…zero6pak (25)in google-contacts • 7 years agoGoogle spreadsheet data to Google Contact using ZapierSomeone 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.…
