Date Time Replacement In IFTTT with settings and functions

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

spreadsheet ifttt arrayformula google settings
6 years ago by

Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

  • Disagreement on rewards
  • Fraud or plagiarism
  • Hate speech or trolling
  • Miscategorized content or spam

Submit
$0.00
    0
    Authors get paid when people like you upvote their post.
    If you enjoyed what you read here, create your account today and start earning FREE STEEM!