Text to Date Field

Pam Ferguson
Pam Ferguson Overachievers Alumni

I have a file that will be automatically uploaded from another source, but the vendor has the date input as text in the following format: 20200113. Is there anyway that I can easily get this information into an actual Date column so that I can report off of it? Any suggestions would be greatly appreciated!

Best Answer

  • Mark Safran
    Mark Safran ✭✭✭✭✭
    Answer ✓

    If you import that "20200113" into a Text/Number column, you can then create an adjacent Date-formatted column and use this formula (wherein [Imported Date] is the name of the column where the raw "20200113" gets put):

    =DATE(VALUE(LEFT([Imported Date]@row, 4)), VALUE(MID([Imported Date]@row, 5, 2)), VALUE(RIGHT([Imported Date]@row, 2)))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!