Formula to determine company specific quarter
I would like to create a formula that assign the quarter (Q1, Q2, Q3 or Q4) to a column based on the submitted date of a form. I don't know if Smartsheet has any built in functions related to quarter but my company's is not standard
Months 2, 3, 4 - Q1
Months 5, 6 ,7 - Q2
How can I do this please? I'm trying to build it like I would in Excel or SQL and that doesn't seem possible.