Date format is wrong
Hi Expert,
I did a data upload via data shuffle from an excel file including the following English dates e.g. Dec 1., Feb 1, April
But in Smartsheet it looks like this:
So it switch the month with the day. My settings are english in smartsheet as well. How can I fix it? Thanks
Answers
-
Importing dates is always a little tricky. My suggestion would be to import them as text and then use a formula to grab each portion of the text string and place appropriately in a DATE function.
I also wonder too (untested) if you could have the dates converted into a number string in Excel and have it pull over correctly into a date type column in Smartsheet that way? I am thinking along the lines of where (for example) 12345 would mean 12 April 2021 or something like that?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives