Extract the text word from a date column

Michael Albano

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?

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!

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!

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!