misha-tgshv

Format IFTTT dates for Google Sheets

Example. Sending data from iOS Reminders to Google Sheet. {{CompletedDate}} value is replaced by any other.

Formatted row

=DATEVALUE(SUBSTITUTE("{{CompletedDate}}"," at ", " ")) + TIMEVALUE(SUBSTITUTE("{{CompletedDate}}"," at ", " ")) ||| {{Title}} ||| {{Notes}}

Out

=DATEVALUE(SUBSTITUTE("June 28, 2020 at 01:26PM"," at ", " ")) + TIMEVALUE(SUBSTITUTE("June 28, 2020 at 01:26PM"," at ", " "))