Month Name written as Text for Today's Date
what function return month name from date "i.e =TEXT(MONTH(TODAY()),"MMM")"?
Best Answer

Nested IFs are useful when you need the full month (eg. January) because they are all different lengths.
But for three digit abbreviations you can use a much simpler formula:
=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3)  2, 3)
Answers

Get month name in smartsheet
6/1/2020
Month = JUN
equvelant to excel "=TEXT(MONTH(TODAY()),"MMM") "

Hi Sam,
The MONTH function in Smartsheet will return a number based on which month is in the date. For example, January is 1.
So if you entered the formula
=MONTH(TODAY())
you would get the answer: 6
Then what we can do with this is use a nested IF statement to tell the formula what text each number should return:
=IF(MONTH(TODAY()) = 1, "JAN", IF(MONTH(TODAY()) = 2, "FEB" .... etc
Does that make sense? Do you want a full formula that goes through all possibilities of what the month is?
Cheers,
Genevieve

@Genevieve P. if I have this formula here =IFERROR(MONTH(Date@row), "") and it's producing a number..what do I need to do to revise this formula so that it produces the name of the month instead?

The formula will need you to identify the text you want to associate with each individual number. For example, if it returns 1, you need to identify if you want that to say "JAN" (like in my example above) or "January" etc.
Your formula of MONTH(Date@row) would replace my previous MONTH(TODAY())
So:
=IF(MONTH(Date@row) = 1, "January", IF(MONTH(Date@row) = 2, "February", IF(MONTH(Date@row) = 3, "March"... etc
Then when you're done, wrap the IFERROR around the entire formula:
=IFERROR(IF(MONTH(Date@row) = 1, "January", IF(MONTH(Date@row) = 2, "February", IF(MONTH(Date@row) = 3, "March"))), "")
Does that make sense? Do you need help spelling out all 12 months, or will this be enough?
Cheers!
Genevieve

Nested IFs are useful when you need the full month (eg. January) because they are all different lengths.
But for three digit abbreviations you can use a much simpler formula:
=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3)  2, 3)

I have found that I use this quite frequently, so I created a helper grid with Month in two formats and the month numbers. Headers are Month, Mon, Num  entered data as January, Jan, 1, February, Feb, 2, etc. and whenever I need to access the month text in either format, I just quickly paste =INDEX({Month}, MATCH((MONTH([Delivery Date]@row)), {Num}, 0)) formula referencing the grid I placed at the top of my Sheets and make that formula a Column Formula.