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
+14- Zapier Expert
- 31294 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
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
+14- Zapier Expert
- 31294 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.
1 person likes this
+6- Zapier Staff
- 6514 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! 🤗
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.