Published: 18 Jan 2019 › Updated: 18 Jan 2019
Date Time Replacement In IFTTT with settings and functions
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 ", " ")),""))
Leave Date Time Replacement In IFTTT with settings and functions to:
Best Posts From zero6pak
We have not curated any of zero6pak's posts yet. But you can encourage our curation team to review posts by visiting them regularly and by referring other readers. Because we give priority to frequently read content.
More Posts From zero6pak
- google query label replacement when using "group by"
- Date Time Replacement In IFTTT with settings and functions
- using query function with importrange
- Enumeration of dates between 'startdate' and 'enddate' using Custom function
- Managing working time using IFFTT (Location based)
- My favorite function ARRAYFORMULA in Google Spreadsheet
- Google Spreadsheet to Google Calendar using Zapier
- eval function in google spreadsheet; multi rows
- Date Time Replacement In IFTTT with google script
- Google spreadsheet data to Google Contact using Zapier