AVG(Collect formula with multiple criteria


Im trying to figure it out how to calculate the average "Days to Closed" for each "Task Owner" in 2021 ("Year"column ). I was trying Avg(collect formula. But i get #invalid ref error.

The formulas i try :

=AVG(COLLECT({Days to Closed}, {Task Owner}, "Chris Jularbal", {Year}, IFERROR(YEAR(@cell), 0) = 2021))


=AVG(COLLECT([Days to Closed]:[Days to Closed], [Task Owner]:[Task Owner], "Chris Jularbal", {Year}, "2021"))

Thank you in advance for your help!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!