Can I calculate percent completion for report from tasks?

My project has two phases, multiple major tasks under each phase with numerous child tasks. Is it possible to create calculations to show the percent complete (using checkboxes) for a report. The report would pull the % complete from each project; Project X, Phase 1 = % complete, Phase 2 = % complete, Project Y, Phase 1 = % complete, Phase 2 = % complete, etc.

Find more posts tagged with

Accepted answers

All comments

Ryan Sides

Hi @KD_HUM are you looking to use the checkbox column so only the checked on rows show up in your report?

If you are using a project configuration on your sheet, the higher level rows auto calculate the % complete based on the CHILDREN if you are using the hierarchy (indent) functionality in SS. Then you would just check on the boxes of the rows you want to show up in the report.

If you aren't using the hierarchy functionality, then you would need to calculate the %Complete yourself with a formula including the CHILDREN function.

KD_HUM

Hi Ryan, thanks for your help. Attaching a basic screenshot that I hope explains it better than I did above. Unsure if this is a report or dashboard - no preference on my end.

SS screenshot.pdf

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.