Formula To Return Value based on Month



I am attempting to recreate a formula I have in Google Sheets to return a quarter number based on the Month. Ex: If a cell has "March", it would be Quarter 1. The original formula involved =IF(OR(ISNUMBER(SEARCH("December", F3)), in Google Sheets and I was able to have it work, albeit with several lines of text after that.

Is this possible to replicate in Smartsheet?

Thank you.


Best Answer

  • Jason Albrecht
    Jason Albrecht ✭✭✭✭✭✭
    Answer ✓

    Hi @GDHernandez,

    Would something like this work for you? Naturally swap out [Column4]14 for the cell providing the date.

    =IF(MONTH([Column4]14) <= 3, "Qtr 1", IF(MONTH([Column4]14) <= 6, "Qtr 2", IF(MONTH([Column4]14) <= 9, "Qtr 3", "Qtr 4")))

    Hope this helps.

    Hope this helps and that you have a great day,

    Jason Albrecht MBA, MBus(AppFin), DipFinMgt

    LinkedIn profile - Open to work


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!