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

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

Find more posts tagged with

Formulas

Accepted answers

All comments

=Chris Palmer

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

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

=Chris Palmer

https://community.smartsheet.com/discussion/comment/412313#Comment_412313

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.