Reg Formula

Options

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

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi @Hariharan

    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.

  • Hariharan
    Options

    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 ?

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 12/12/23
    Options

    @Hariharan

    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.

  • Hariharan
    Options

    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.


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    @Hariharan

    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!