Averages and Counts

I'm trying to obtain the average percentage of completion of the goal progress for all the goals associated with a specific team member.

Please help! :)

This is the formula I'm using:

=AVERAGEIF([PROJECT TEAM]:[PROJECT TEAM], [GOAL PROGRESS]:[GOAL PROGRESS], FIND("Ed Brandt", @cell) > 0)

Thank you!!

Wendy

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi Wendy,

    The structure of an AVERAGEIF is as follows: Range with Criteria, then the Criteria, then finally the Range to Average. These would be the different elements, for your sheet:


    Range with Criteria: [PROJECT TEAM]:[PROJECT TEAM]

    Criteria: HAS(@cell, "Contact Name")

    Range to AVG: [GOAL PROGRESS]:[GOAL PROGRESS]


    With that in mind, try this full formula:

    =AVERAGEIF([PROJECT TEAM]:[PROJECT TEAM], HAS(@cell, "Contact Name"), [GOAL PROGRESS]:[GOAL PROGRESS])


    I used HAS because it was built specifically for multi-select drop-down columns, for contact lists or regular lists. Let me know if this works for you, or if you have any questions!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!