How to specify format for date formulas?
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! :)
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!