Every time I try to link the date of a Monday Board pulse to a Google Sheet it shows up as a cryptic number. I've tried multiple tests with different pulses but it doesn't seem to carry over correctly. Any ideas on how to fix this? Thanks in advance.
EX: 03/04/24 = 45035
Best answer
Dates transferring as cryptic numbers when connecting monday.com to Google Sheets.
Best answer by Troy Tessalone
Hi
In GSheets, format the column as a Date.
Help: https://support.google.com/docs/answer/56470?hl=en&co=GENIE.Platform%3DDesktop
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
- 34052 replies
- Answer
Hi
In GSheets, format the column as a Date.
Help: https://support.google.com/docs/answer/56470?hl=en&co=GENIE.Platform%3DDesktop
+14- Zapier Orchestrator & Solution Partner
- 34052 replies
As an alternative, use Airtable, which has specific column types for data.
Wow I assumed the problem was more complicated than that hahahah wow huge relief thank you so much.
+6- Zapier Staff
- 6780 replies
That’s awesome news
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.