Date Format Question

Hello Smartsheet Community,

How can I get the Date Helper column below to automatically show the date format as D-M-YYYY? There is a formula in that column and it's a date column. When I click on the date format button and select another format type, it does not do anything. The D-M-YYYY format seems to be the only one that works with the month formula.

Below is what I'd like it to look like. I did this manually and would need it to be automatic.

Thank you!!

Find more posts tagged with

Accepted answers

All comments

heyjay

=LEFT([Date Column]@row, FIND(" ", [Date Column]@row, LEN(LEFT([Date Column]@row, FIND(" ", [Date Column]@row) - 1))))

Looks like your initial formula is including a space at the end. I used len to subtract 1 from the result.

Lea722

Thank you for your response! How can I get the date format to show as D-M-YYYY even though there is a formula in the column? I have the formula applied to the whole column. I can't get mine to show like yours with the formula you shared.

I appreciate you taking the time to help!

Lea722

I figured out another solution :)

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.