Refer to a date and return the fiscal year


Looking for some assistance with a formula that refers to a column (DOS) and depending upon the date range it falls into, it returns the fiscal year.

I'm using IF and I'm getting #unparsable so I don't have it written properly.

=IF([email protected] > DATE(2022,6,30), “FY22”, “X”)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!