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?
Help Article Resources
Check out the Formula Handbook template!