Solved

Google Sheets not recognizing YYYY-MM-DDTHH:MM:SS format

  • 13 January 2021
  • 1 reply
  • 22 views

I have Zapier adding Infusionsoft data into rows into Google Sheets. The data from Infusionsoft (created date of contact) uses what I thought was a common date-time format:

2021-01-06T16:33:50

But it seems like Google Sheets isn't recognizing this data as a date.

Can anyone help?

I’d rather not use Zapier’s formatter because it will double the number of actions this Zap uses (and it has a high throughput)

icon

Best answer by Wemakefuture 14 January 2021, 07:40

Hey there I would advise you to use zapier. It's formated is rock solid and can handle many many different formats incoming. 

 

In case you really want to try something with google you need to play around with functions.

 

https://www.google.com/amp/s/infoinspired.com/google-docs/spreadsheet/how-to-use-the-text-function-in-google-sheets/amp/

View original

1 reply

Userlevel 6
Badge +6

Hey there I would advise you to use zapier. It's formated is rock solid and can handle many many different formats incoming. 

 

In case you really want to try something with google you need to play around with functions.

 

https://www.google.com/amp/s/infoinspired.com/google-docs/spreadsheet/how-to-use-the-text-function-in-google-sheets/amp/

Reply