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
Check out the Formula Handbook template!