How can I convert YYYYMMDD to a SmartSheet date value?

Anirudh

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?

Anirudh

Nevermind. Used a combination of LEFT, MID, and RIGHT functions to convert the numbers to dates.

Anirudh

Nevermind. Used a combination of LEFT, MID, and RIGHT functions to convert the numbers to dates.

markmontour-larson102391

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)

jg124

@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!