How to reverse text?

Anya Brudzinska

Hello,

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!

Mike Wilday

Try this formula:

=RIGHT([Life End Date]@row, 2) + "-" + LEFT([Life End Date]@row, 2) + "-" + MID([Life End Date]@row, 4, 2)

Does it work?

Mike Wilday

This article might be of assistance.

https://help.smartsheet.com/articles/2479481-apply-standardized-date-formats-in-your-sheet

Anya Brudzinska

@Mike Wilday Thank you, but this option doesn't work in the text column :(

Mike Wilday

Try this formula:

=RIGHT([Life End Date]@row, 2) + "-" + LEFT([Life End Date]@row, 2) + "-" + MID([Life End Date]@row, 4, 2)

Does it work?

Anya Brudzinska

@Mike Wilday YES!!!! Thank you!!! I tried to work the formula, but I was missing the '+ "-" +' part.

Mike Wilday

Awesome. Please accept my answer! :D