How can I convert YYYYMMDD to a SmartSheet date value?
I have about 2500 date values, imported from an Excel spreadsheet, in the YYYYMMDD numerical format. I would like to convert them to Smartsheet date values.
Any suggestions?
Best Answer
-
Nevermind. Used a combination of LEFT, MID, and RIGHT functions to convert the numbers to dates.
Answers
-
Nevermind. Used a combination of LEFT, MID, and RIGHT functions to convert the numbers to dates.
-
You might try;
Create a Text column for your (YYYYMMDD) source dates (I've called it 'input' in this formula).
Create a Date column to capture the reformatted date. Place this formula into the Date column;
=MID(input@row, 5, 2) + "/" + RIGHT(input@row, 2) + "/" + LEFT(input@row, 4)
-
@Anirudh could you please share how you did it? I am using pivot app that is importing dates from a sub sheet in yyyy-mm-dd format and need to convert it to a date for the date column. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!