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
Help Article Resources
Check out the Formula Handbook template!