Formula for Average If

Options

I read you have to use COLLECT if you want to average using multiple conditions.

I want to average the difficulty rankings of all projects with the same project lead and project status. The difficulty rank is Difficulty. The project status is the Metric@Row.

All I get is #INCORRECTARGUMENT.

Help?


Example formula

=AVG(COLLECT({Project Lead}, "Amy", {Status}, Metric@Row, {Difficulty}))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!