Average Collect Formula

i want to add =Average(Collect()) to the formula below while wanting to know the average for {Formal Total}. The below is the criteria for it.

({Formal Capacity}, >=10, {Formal Capacity}, <=269, {Date Budget Formal}, IFERROR(YEAR(@cell ), 0) = 2021)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!