Using the Average(Collect) formula

I am trying to create a formula that will calculate the average days of a column if the FY column = FY2021

This is the formula that I am using but is keeps giving me an error

This is the data sheet I am using:

Any ideas how to get this to work? Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!