• zero6pak (25)in #spreadsheet • 6 years ago

  google 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…

  $0.00

   0 2
• zero6pak (25)in #spreadsheet • 6 years ago

  Date Time Replacement In IFTTT with settings and functions

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

  $0.00

   0 0
• zero6pak (25)in #spreadsheet • 6 years ago

  using query function with importrange

  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…

  $0.00

   0 0
• zero6pak (25)in #spreadsheet • 6 years ago

  Enumeration of dates between 'startdate' and 'enddate' using Custom function

  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…

  $0.00

   1 0
• zero6pak (25)in #dtube • 7 years ago

  Managing working time using IFFTT (Location based)

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

  $0.00

   1 3
• zero6pak (25)in #arrayformula • 7 years ago

  My favorite function ARRAYFORMULA in Google Spreadsheet

  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…

  $0.00

   1 0
• zero6pak (25)in #spreadsheet • 7 years ago

  Google Spreadsheet to Google Calendar using Zapier

  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…

  $0.00

   2 0
• zero6pak (25)in #eval • 7 years ago

  eval function in google spreadsheet; multi rows

  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…

  $0.00

   1 0
• zero6pak (25)in #spreadsheet • 7 years ago

  Date Time Replacement In IFTTT with google script

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

  $0.00

   1 0
• zero6pak (25)in #google-contacts • 7 years ago

  Google spreadsheet data to Google Contact using Zapier

  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…

  $0.03

  • Past Payouts $0.03
  • - Author $0.03
  • - Curators $0.00

   2 1