Calculate Average of Task Progress, per Person

GWOOD02

Hello,

I am trying to create a dashboard showing the average task completion status' of a number of team members.

I feel this needs to be completed in Sheet Summary, but can't figure the right formula...

Essentially trying to get; AVG of Column [Status], IF Assigned to [Joe]

Any clues? thanks

PS. the dark rows are parent rows, calculating the overall average status of it's children

Find more posts tagged with

Sheets

Formulas

Reports

Dashboards

Sheet Summary

Accepted answers

Shubham

Hi GWOOD02,

Please try the follwing formula-

=(AVERAGEIF([Assigned To]:[Assigned To], "Joe", Status:Status)) * 100

You just need to change the name in the formula, and it will return the average of that person.

Thank you,

Shubham Umale

Associate - Smartsheet, Ignatiuz Software

GWOOD02

Beautiful! That worked perfectly. Thanks so much @Shubham

All comments

Shubham

Hi GWOOD02,

Please try the follwing formula-

=(AVERAGEIF([Assigned To]:[Assigned To], "Joe", Status:Status)) * 100

You just need to change the name in the formula, and it will return the average of that person.

Thank you,

Shubham Umale

Associate - Smartsheet, Ignatiuz Software

GWOOD02

Beautiful! That worked perfectly. Thanks so much @Shubham

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.