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

Nat · 01/08/24

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"?

=Chris Palmer · 01/08/24

Hello @Nat,

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

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

Nat · 01/08/24

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

=Chris Palmer · 01/08/24

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

Answers