Formula for Status Summary Report and Project Task Completion

Hi Smartsheet Team,

I have the following charts. Left one, I retrieve the data from Status Summary Report. On the right side, I have the formula to calculate the Project task completion. However, you will see the complete % is different between these 2.

My "Not Started" in Sheet Summary formula is =COUNTIFS([Count of Children]:[Count of Children], =0, Status:Status, "Not Started"). Can you advise how I can make these 2 charts figures consistent? Thanks!

Find more posts tagged with

Formulas

Dashboards

Accepted answers

All comments

AravindGP

Hi There,

Both of the values might not be consistent as the % Complete formula (that is auto applied) looks at duration and not just the number of tasks. In comparison, your countif formula is only looking at the number of tasks. A suggestion to best represent both of them without causing this confusion would be to show the "Tasks by Status" chart as absolute numbers (i.e., number of tasks by status instead of percentages) and leave the "Project Task Completion" as a percentage.

AAL

Good Idea, Aravind. Thank you!

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.