If current Fiscal Year, check box


I am trying to create a formula that checks a box if the date in the Date Column is this fiscal year - which for us is July - June.

Here is what I have so far which is not giving me an error but also not checking the box for the date which is this FY (4/22/22).

=IF(AND(MONTH([Date]@row) > 6, YEAR([Date]@row) + 1 = "2022"), 1, 0)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!