How can I convert YYYYMMDD to a SmartSheet date value?

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

  • AnirudhAnirudh
    Accepted Answer

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

Answers

Sign In or Register to comment.