# Formula To Return Value based on Month

Options
✭✭✭✭

Hello,

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.

Tags:

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭
edited 04/03/23
Options

It did, thank you Jason! It took some tweaking on my end, but with your formula I was able to get this working. Thank you! @Jason Albrecht

• ✭✭✭✭✭✭
Options

Great news.

Thank you for the feedback.

Have a great day.

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!