• Sign in
  • Sign up 
  • Welcome
  • FAQ
  • Block Explorer 
  • Night Mode
  • Stolen Accounts Recovery 
  • Change Account Password 
  • Vote for Witnesses 
  • Hive Proposals 
  • OpenHive Chat 
  • Developer Portal 
  • Hive Whitepaper 
  • Privacy Policy
  • Terms of Service
logo
  • Posts
  • Proposals
  • Witnesses
  • Our dApps
LoginSign up

Date Time Replacement In IFTTT with settings and functions

zero6pak (25)in #spreadsheet • 7 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
7 years ago in #spreadsheet by zero6pak (25)
$0.00
    Reply 0
    Sort:  
  • Trending
    • Trending
    • Votes
    • Age