Formatting Dates

I am copy and pasting reference data that contains dates as text. How can I link to a field and get it to format it as a date. The data looks like this Tuesday, August 16, 2022, but Smartsheet does not recognize it as a date.

I tried this

=[OPD Data]24{DATE(2021,5,5)}

Answers

  • Paul McGuinness
    Paul McGuinness Overachievers

    Hi @smeyermmec

    This formula will work and should work for all months, if the structure of your import data changes you will need to tweak the formula

    =LEFT(RIGHT([Test date]@row, 8), 2) + "/" + IF(CONTAINS("January", [Test date]@row), 1, IF(CONTAINS("February", [Test date]@row), 2, IF(CONTAINS("March", [Test date]@row), 3, IF(CONTAINS("April", [Test date]@row), 4, IF(CONTAINS("May", [Test date]@row), 5, IF(CONTAINS("June", [Test date]@row), 6, IF(CONTAINS("July", [Test date]@row), 7, IF(CONTAINS("August", [Test date]@row), 8, IF(CONTAINS("September", [Test date]@row), 9, IF(CONTAINS("October", [Test date]@row), 10, IF(CONTAINS("November", [Test date]@row), 11, IF(CONTAINS("December", [Test date]@row), 12, "Error")))))))))))) + "/" + RIGHT([Test date]@row, 4)

    Hope it helps

    Thanks

    Paul

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!