Ecency
#spreadsheet
Date Time Replacement In IFTTT with settings and functions

Date Time Replacement In IFTTT with settings and functions

zero6pak(25)

Published in

#spreadsheet

Words

Reading

0 min

Listen

Play

2019-01-18 04:21

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 ", " ")),""))

spreadsheet

ifttt

arrayformula

2019-01-18 04:21

This post was published via steemit. Ecency is not the originator or editor of this content and displays it for discovery purposes only.

$ 0.000

Read next

Learn Zig Series (#3) - Functions and Control Flowscipio · 3 months ago Exporting Videos in Kdenlive Choosing the Best Render Settings for Every Platformhansama · 3 days ago

Settings Interfacemawit07 · 6 months ago

“AI comes to the browser… Google launches ‘Gemini in Chrome’ in Korea”yann03 · 2 months ago

From @zero6pak

google query label replacement when using "group by"zero6pak · 7 years ago

using query function with importrangezero6pak · 7 years ago

Enumeration of dates between 'startdate' and 'enddate' using Custom functionzero6pak · 7 years ago

Managing working time using IFFTT (Location based)zero6pak ·

In #spreadsheet

Hive-Engine Downed: A Cautionary Tale! revisesociology · a year ago

Art & Crafts, Work & Motivation. Spreadsheets! - My approach to chipping away at big targetszakludick · a year ago CRO Number Crunching - Nov 10 2024shainemata · 2 years ago

Adulting With Spreadsheet The Secret Weapon To Productivity and Life Management

Date Time Replacement In IFTTT with settings and functions | Ecency