Date and time cell becomes Date only cell on import
When I import a exel file into SS, why does it turn 2020-03-23 08:00:00, into 05/14/20? If there is a way to fix this, preferably from the api, that would be great.
Answers
-
Hi Christopher,
It's hard to tell what's going on without seeing the excel file... I would suggest reaching out to Smartsheet Support and providing them with the file to test, as those dates are very different. Screen captures would also be useful.
Thanks!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
They're actually meant to be the same date, mistake on my part, but the format is the important part.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives