Need help calculating the average of a column based on multiple criteria.

I am attempting to average the number of days to complete Action Items based on multiple criteria. I am using the =AVG(COLLECT) formula below but it is not calculating correctly. Any suggestions?

=AVG(COLLECT({5S& Safety Observations Range 3}, {5S& Safety Observations Range 1}, $Jan$1), {5S& Safety Observations Month Name}, $Jan26, {5S& Safety Observations Range 6}, $[Primary Column]@row)

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!