How to specify format for date formulas?

Liz Lomax

Hi all,

If I'm using a formula such as '=MONTH(TODAY()) , how do I tell smartsheet to return the name of the month instead of the number? eg: "September" instead of "9"

In excel it would be '=TEXT(TODAY(), "mmmm") but this smartsheet doesn't seem to like this. What is the smartsheet equivalent?

I am not prepared to prick around with 12 IF statements as I've seen suggested elsewhere... surely "Smart" Sheet is smarter than that?

TIA! :)

Andrée Starå

Hi @Liz Lomax

I hope you're well and safe!

Unfortunately, it's not possible to change it without the IF formula or a Workflow, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

• Workflow with the Change a Cell action for each month (if 1 = January)
• Multiple IF formula structure. Something like this.

=IF(ColumnName@row <> "", 
IF(MONTH(ColumnName@row) = 1, "01 January", 
IF(MONTH(ColumnName@row) = 2, "02 February", 
IF(MONTH(ColumnName@row) = 3, "03 March", 
IF(MONTH(ColumnName@row) = 4, "04 April", 
IF(MONTH(ColumnName@row) = 5, "05 May", 
IF(MONTH(ColumnName@row) = 6, "06 June", 
IF(MONTH(ColumnName@row) = 7, "07 July", 
IF(MONTH(ColumnName@row) = 8, "08 August", 
IF(MONTH(ColumnName@row) = 9, "09 September", 
IF(MONTH(ColumnName@row) = 10, " 10 October", 
IF(MONTH(ColumnName@row) = 11, "11 November", 
IF(MONTH(ColumnName@row) = 12, "12 December")))))))))))))

Would any of those options work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!