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(DOS@row > DATE(2022,6,30), “FY22”, “X”)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!