Date Time Replacement In IFTTT with settings and functions

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

If you need to use google datevalue, timevalue functions in IFTTT, you should change settings.

You can use arrayformula function without google script.

=ARRAYFORMULA(IF(A2:A<>"",TIMEVALUE(SUBSTITUTE(A2:A," at ", " ")) + DATEVALUE(SUBSTITUTE(A2:A," at ", " ")),""))

6 years ago in #spreadsheet by zero6pak (25)

$0.00

STEEM 0.25

TRX 0.19

JST 0.036

BTC 93397.76

ETH 3352.57

USDT 1.00

SBD 3.86