# Reg Formula

For example If we use the below formulas

Current month:

=MONTH(TODAY()) + ", " + YEAR(TODAY())

Previous Month:

=IF(MONTH(TODAY()) = 1, 12, MONTH(TODAY()) - 1) + ", " + IF(MONTH(TODAY()) = 1, YEAR(TODAY()) - 1, YEAR(TODAY()))

I get Values as below using the above formulas what is the way to get the Months in Text for Example (December, 2023; November, 2023; October, 2023 etc.......)

12, 2023

11, 2023

10, 2023

9, 2023

• ✭✭✭✭✭✭

I hope you're well and safe!

Try something like this. (update/modify as needed)

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

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

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, Awesome, 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.

• Hi Andree, I tried its not working actually. What is the Column type we need to setup? Is there any other way to get this ?

• ✭✭✭✭✭✭
edited 12/12/23

Can you paste the exact formula you tested? It should be either a text or a dropdown column.

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome 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.

• Hi Andree,

I used below formulas to get Values on MM, YYYY column its type is Text/ Number.

=MONTH(TODAY()) + ", " + YEAR(TODAY())

=MONTH(TODAY()) - 1 + ", " + YEAR(TODAY())

=MONTH(TODAY()) - 2 + ", " + YEAR(TODAY()) etc.....

What is the formula I can use to get values on Test formula please suggest some dynamic formula. The year should automatically take only the current year.

• ✭✭✭✭✭✭

Try something like this.

=

IF(Month@row <> "",

IF(MONTH(Month@row) = 1, "01 Jan",

IF(MONTH(Month@row) = 2, "02 Feb",

IF(MONTH(Month@row) = 3, "03 Mar",

IF(MONTH(Month@row) = 4, "04 Apr",

IF(MONTH(Month@row) = 5, "05 May",

IF(MONTH(Month@row) = 6, "06 Jun",

IF(MONTH(Month@row) = 7, "07 Jul",

IF(MONTH(Month@row) = 8, "08 Aug",

IF(MONTH(Month@row) = 9, "09 Sep",

IF(MONTH(Month@row) = 10, " 10 Oct",

IF(MONTH(Month@row) = 11, "11 Nov",

IF(MONTH(Month@row) = 12, "12 Dec")))))))))))) + ", " + YEAR(Month@row))

Did it work?

Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!