Hi you all,
I have a zap that passes information from typeform to gsheet, one field is "start date" but instead of giving me the date: 2021-08-20T14:24:12S it started giving me a random number that looks like this: 44428,68347
The number has no format in gsheet, can some one help me out please?
Best answer by Troy Tessalone
Hi
You may need to set the GSheet column Format:
+9Hi
This looks like a unix timestamp, what you need to do is add a date/time formatter before Google Sheet in the Zap. The formatter will be able to convert the unix timestamp to actual readable date-time value.
+14Hi
You may need to set the GSheet column Format:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
