Formula to determine company specific quarter

Options

Hi


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

Etc.

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.

Thanks,


Lisa

Answers