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.
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([email protected], 5, 2) + "/" + RIGHT([email protected], 2) + "/" + LEFT([email protected], 4)