Formula to determine company specific quarter

LisaJ
ββ
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
-
Hi @LisaJ,
Try this:
="Q" + IF(MONTH([Submitted Date]@row) = 1, 4, INT((MONTH([Submitted Date]@row) + 1) / 3))
All the best!
Sandra