Change Text/Number to valid date

tgattsh
tgattsh ✭✭✭✭
edited 01/26/24 in Formulas and Functions

I'm using a date in the primary column, of course Smartsheet sees this as just text/number. I've added a column called "Date" and want to convert the Text/Number to an actual date.

Primary Column...........Date

1/29/2024....................01/29/24

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!