How to reverse text?



I need to reverse the format of a date stored as text. I used the =(life end date) + "" formula, hoping it would convert exactly as the date column format (YYYY_MM_DD), but nope... it populates as MM-DD-YY.

How can I reverse the order? I'm fine with two-digit year, I just really need it to show as year/month/day. Thank you in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!