# Abbreviate year that is returned using formula (to obtain fiscal year quarter)

Options
✭✭✭✭✭

Happy new year Smartsheet crew!

I'm returning the quarter of my end date using this formula:

=IF(MONTH([End Date]@row) <= 3, "Q4", IF(MONTH([End Date]@row) <= 6, "Q1", IF(MONTH([End Date]@row) <= 9, "Q2", "Q3")))

And the Fiscal Year using this:

=IF(MONTH([End Date]@row) > 3, YEAR([End Date]@row) + 1, YEAR([End Date]@row))

However, it returns the full year - eg "2025"

I want to end up with a third column joining them to end up with "Q1 FY25" - so how do I turn that "2025" into just "25"?

Tags:

• ✭✭✭✭✭
Options

Hello @Nat,

In your third column this might be sufficient for what you need:

=[Quarter Column]@row + " FY" + RIGHT([Full Year Column]@row,2)

• ✭✭✭✭✭
Options

Thanks @Mr. Chris that worked and allows me to easily fit this into my set of report templates - much appreciated!

• ✭✭✭✭✭
Options

Thanks for the feedback, I'm glad this worked for you!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!