Login
Discover
Waves
Decks
Upgrade
Login
Signup
Topics
New
Trending
Hot
New
New
Trending
Hot
New
Controversial
Rising
Promoted
arrayformula
zero6pak
spreadsheet
Friday, January 18, 2019 4:21 AM
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
Saturday, January 12, 2019 3:16 AM
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
arrayformula
Friday, January 5, 2018 11:40 AM
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
eval
Monday, January 1, 2018 2:42 AM
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
Top communities
Create decentralized community