How can I convert date to text?

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!

Find more posts tagged with

Data Shuttle

Accepted answers

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.