Separating out a date by Quarter and Year


I have an End Date column (which is formatted as mm/dd/yyyy). I need a formula to show as Q1-2022 (example) for any given date in the column.

In excel, I was able to find a formula that works but transferring it to Smartsheet I receive an UNPARSEABLE error message. That formula is: ="Q"&INT((MONTH(End Date)+2)/3)&YEAR(End Date)

I believe one of my issues is Smartsheet uses + instead of & but from there I feel lost (probably trying to figure it out for too long now). Any help is greatly appreciated.

Thank you in advance

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!