Formula To Return Value based on Month

GDHernandez

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.

Jason Albrecht

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.

Jason Albrecht

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.

GDHernandez

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

Jason Albrecht

Great news.

Thank you for the feedback.

Have a great day.