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

Sandra Guzman

Hi @LisaJ,

Try this:

="Q" + IF(MONTH([Submitted Date]@row) = 1, 4, INT((MONTH([Submitted Date]@row) + 1) / 3))

All the best!

Sandra