I want to take the average score of a column (which uses the star symbols on a 1-5 ranking system), when another column has a specific provider listed.

My formula looks like this but I'm getting unparseable. =AVG(COLLECT({Master Provider Scorecard Range 1}, {Master Provider Scorecard Range 2}, "Provider A"))


  • L_123
    L_123 ✭✭✭✭✭✭
    edited 07/08/21

    you can't average a boolean expression, instead try adding a helper column with a stacked if statement to convert the symbols to integers, then average the integers.

    *or you can use stacked countifs to avoid the helper column

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!