Planned vs actual progress (Summary level)

Hi everyone, I am trying to calculate the % Planed based on the start and finished dates but when I try to set the Complete (actual) progress just to verify that all of my plan y on date, I see that the summary tasks are not calculated correctly. I am using the following formula

=ROUND(IF(TODAY() < [Baseline Start]@row , 0, IF(TODAY() >= [Baseline Finish]@row , 1, NETWORKDAYS([Baseline Start]@row , TODAY()) / NETWORKDAYS([Baseline Start]@row , [Baseline Finish]@row ))), 2)

As u see in the attachment, the %Planed is less than the %Complete but all of the following activities are according to the %Planed

I hope you can help me

thanks

Tania

Find more posts tagged with

Sheets

Formulas

Accepted answers

All comments

Cassie L

@ttabares Smartsheet uses a weighted average formula for % Complete based on the duration. Using the following formula in your highlighted cell, you can see how Smartsheet got this result:

=AVGW([% Complete]2:[% Complete]5, Duration2:Duration5)

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.