How can I convert date to text?

SUNNY_BUNNY

Hi, I'm setting up data shuttle where unique identifier can be in multiple dates and would need to make sure all data in multiple days flow. In excel, I have a helper column as =ID&"_"&TEXT(Date, "yyyymmdd") to set as an unique identifier. From the Smartsheet that has a date of 7/23/24, how can I convert this into 20240723? That way it becomes unique to have ID 123456 to be 123456_20240723 where there might be entry on 123456_20240722 and this doesn't get recognized as duplicated entry. Don't seems to have a formula to convert.

Thank you!

Paul Newcome

You would need this to convert the date:

=YEAR([Date Column]@row) + "" + RIGHT("0" + MONTH([Date Column]@row), 2) + RIGHT("0" + DAY([Date Column]@row, 2)