zero6pak (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…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…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…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]…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…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…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…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.…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.…