• Sign in
  • Sign up 
  • Welcome
  • FAQ
  • Switch to Night Mode
  • Stolen Accounts Recovery 
  • Change Account Password 
  • Vote for Witnesses 
  • Steem Proposals 
  • Developer Portal 
  • Steem Bluepaper 
  • SMT Whitepaper 
  • Steem Whitepaper 
  • Privacy Policy
  • Terms of Service
Homeby Witness Moecki
LoginSign up

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.

Selection_086.png

Selection_087.png

You can use arrayformula function without google script.

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

nd.png

#ifttt #arrayformula #google #settings
6 years ago in #spreadsheet by zero6pak (25)
$0.00
    Reply 0