#arrayformula

Follow to get notified about new posts with this tag

zero6pak

8y

Date Time Replacement In IFTTT with settings and functions

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

8y

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

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

9y

!Low reputation account with an unverified outbound link, Reveal content

My favorite function ARRAYFORMULA in Google Spreadsheet

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

zero6pak

9y

!Low reputation account with an unverified outbound link, Reveal content

eval function in google spreadsheet; multi rows

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