markwhat1
1/9/2016 - 11:21 PM

Make IFTTT Date Format play nice with Google Spreadsheets

Make IFTTT Date Format play nice with Google Spreadsheets

IFTTTDate.md
content_copyfile_download
  • Rendered
  • Source

##Date and Time

=TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) + DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))

##Date

=DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))

##Time

=TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))

To Use

Simple just place either or both separated by ||| in the
Formatted Row Input on IFTTT