Offload Date Format
Hi,
I'm using Data Shuttle to Offload a title and some dates and it is coming through with a really wonky format.
Excel isn't able to auto convert this to a regular date and I tried using INT to try to make it into and integer but it returns a #VALUE! error because of the format.
Is there any solution to this? This seems like a issue that really impedes the usefulness of Data Shuttle.
Best Answer
-
Those strings are stored as text in Smartsheet. They are not stored as dates. You will need a helper column in Smartsheet (date type) with a formula to grab the date out.
=DATE(VALUE(LEFT([Column Name]@row, 4)), VALUE(MID([Column Name]@row, 6, 2)), VALUE(MID([Column Name]@row, 9, 2)))
Answers
-
Those strings are stored as text in Smartsheet. They are not stored as dates. You will need a helper column in Smartsheet (date type) with a formula to grab the date out.
=DATE(VALUE(LEFT([Column Name]@row, 4)), VALUE(MID([Column Name]@row, 6, 2)), VALUE(MID([Column Name]@row, 9, 2)))
-
Nice! Thanks @Paul Newcome !
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives