New: arrayformulaAll contenthive-129948hive-196917krzzansteemhive-183959hive-180932photographyhive-150122hive-185836uncommonlabhive-166405lifehive-183397hive-144064bitcoinhive-188619hive-139150krsuccesshive-101145hive-180301hive-103599hive-124908hive-120861hive-184714TrendingNewHotLikerszero6pak (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 arrayformula function without google script.…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] [formular] we can extract dates from working duration without adding any repeated…zero6pak (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, using google form and so on. Because Google forms data should be written at…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 eval( s) } But, it cannot use multi rows. If you want apply multi rows one…
