How do I change a date format in a formula to long date format?

Hello! I am setting up a meeting agenda in WorkApps and have a date column that displays the date in a long date format to avoid confusion between regions: Sep 28, 2020.

I would like this date format to show in a formula. The pre-set formula is simply =[Next meeting]@row + " Meeting Agenda", so that looks like this: 09/28/20 Meeting Agenda

However, I would it to look like this: Sep 28, 2020 Meeting Agenda.

How do I do that?

Thanks so much!

Find more posts tagged with

Accepted answers

All comments

bisaacs

Hey @Anna Rain,

You'll need to use IF statements and concatenate to return the desired result:

=IF(MONTH(Date@row) = 1, "January" + " " + DAY(Date@row) + ", " + YEAR(Date@row) + " Meeting Agenda", IF(MONTH(Date@row) = 2, "February" + " " + DAY(Date@row) + ", " + YEAR(Date@row) + " Meeting Agenda", IF(MONTH(Date@row) = 3, "March" + " " + DAY(Date@row) + ", " + YEAR(Date@row) + " Meeting Agenda", IF(etc....))))

Hope this helps!

Anna Rain

Thanks so much for your quick response. I can't make it work but I think that's probably because I need to learn the basics... (I'm pretty new to Smartsheet.) I will take a look at Smartsheet University and try again once I know what I'm doing. ;)

Thanks!

bisaacs

Hey @Anna Rain,

Can you copy your formula that's not working? The issue could be as simple as forgetting a comma or not closing off a parenthesis!

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.