Average IF or Avg(Collect) to obtain the average of multiple scoring values


Hello Everyone... I am a bit new to Smartsheet and trying to find my way. I have an issue where I have an external reference to a 2nd sheet to collect a point total for how thoroughly some questions are being answered. I have up to 8 different people who will be scoring the responses and these scores will be tied to the responses with an Application ID value. My example formula is below...

=AVERAGE(COLLECT({PartnerScoreTotalRange},{PartnerScoreAppID_Range},App_ID:App_ID @cell = [App_ID]@row))

Any help would be greatly appreciated...

Thanks In Advance!


Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓


    =AVG(COLLECT({PartnerScoreTotalRange},{PartnerScoreAppID_Range}, @cell = [App_ID]@row))



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!