Quarter Formula

Felicia Nabors
Felicia Nabors ✭✭✭
edited 02/22/23 in Formulas and Functions

I am trying to create a formula that extrapolates the quarter (Q1, Q2, etc) based upon the end date column. Has anyone done this before?

Thanks in advance for any help provided.

Best Answer

  • Lucas Rayala
    Lucas Rayala ✭✭✭✭✭✭
    Answer ✓

    I use this although I'm not sure if this works beyond the last year. I wrote it a while back.

    = "Q" + ((ROUNDDOWN(((YEARDAY([End Date]@row) - 5) / 365) * 4)) + 1) + "-" + RIGHT([End Date]@row, 2)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!