Fiscal Year and Quarter Designation


Hi Folks,

Not the best with formulas and struggling with trying to generate a fiscal year Quarter and Year (for example Q1-2023) based off a date column. Fiscal year starts on July 1st. Appreciate any help in advance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!