How can I convert YYYYMMDD to a SmartSheet date value?

Anirudh · 03/25/20

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 · 03/25/20

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

Anirudh · 03/25/20

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

markmontour-larson102391 · 03/25/20

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 · 02/25/21

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

How can I convert YYYYMMDD to a SmartSheet date value?

Best Answer

Answers

Help Article Resources

Categories