Discover
Communities
Decks
Login
Discover
Communities
Decks
Buy perks
Login
Signup
25
zero6pak
Available
Used
Resource Credits
111 Followers
38 Following
December 26, 2017
RSS feed
Posts
Blog
Posts
Comments
Communities
Wallet
Mute
zero6pak
spreadsheet
6y
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, SUM(G) GROUP BY F
$ 0.000
0
2
zero6pak
spreadsheet
6y
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.000
0
zero6pak
spreadsheet
6y
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 ........... Condition syntax rules are
$ 0.000
0
zero6pak
spreadsheet
6y
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 any repeated codes. [script] function
$ 0.000
1
zero6pak
dtube
7y
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.000
1
3
zero6pak
arrayformula
7y
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 should be written at last row's
$ 0.000
1
zero6pak
spreadsheet
7y
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 date specific form. The specific
$ 0.000
2
zero6pak
eval
7y
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 apply multi rows one time, you can
$ 0.000
1
zero6pak
spreadsheet
7y
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.000
1
zero6pak
google-contacts
7y
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 phone using Zapier. (must join
$ 0.032
2
1
Follow, be first to know
Nothing found in posts.