Extract the text word from a date column

I am trying to pull the day text (Monday, Tuesday, etc.) from a date column using a formula. SS AI tool tells me to use:

=TEXT([Meeting Date]@row, "dddd")

but that gives me the #UNPARSEABLE error.

What am I missing?

Find more posts tagged with

Accepted answers

SSFeatures

Hi @Michael Albano,

@AdamSYNH's answer is excellent!

I'd also recommend using a different AI service for Smartsheet formulas in the future. I use ChatGPT's 4o model and get pretty good results compared to Smartsheet's AI. The downside is that you have to tell ChatGPT more about your sheet, since it doesn't have direct context from your sheet.

Best!

All comments

AdamSYNH

Hi @Michael Albano,

Try this:

=IF(WEEKDAY(Date@row) = 1, "Sunday", IF(WEEKDAY(Date@row) = 2, "Monday", IF(WEEKDAY(Date@row) = 3, "Tuesday", IF(WEEKDAY(Date@row) = 4, "Wednesday", IF(WEEKDAY(Date@row) = 5, "Thursday", IF(WEEKDAY(Date@row) = 6, "Friday", IF(WEEKDAY(Date@row) = 7, "Saturday"))))))), "")

SSFeatures

Hi @Michael Albano,

@AdamSYNH's answer is excellent!

Best!

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.