% Complete is Incorrect

MelM18 · 04/25/24

In project settings I have dependencies enabled. This auto calculates % complete; however, the. percentage is incorrect.

In my example I have 2 Parent rows, each with 5 tasks. Everything under Parent 1 is complete and everything under Parent 2 is not started. The % complete should be 50%; however it shows 43% complete.

I am able to determine the expected complete using this formula:

=IF(Status@row = "Pending", 0, IFERROR(AVG(CHILDREN()), IF([End Date]@row <= TODAY(), 1, IF([Start Date]@row >= TODAY(), 0, IF([Start Date]@row <= TODAY(), NETWORKDAYS([Start Date]@row, TODAY()), 0) / NETWORKDAYS([Start Date]@row, [End Date]@row)))))

My goal is to compare the % Expected Complete against the (actual) % Complete columns to identify where we have a variance.

Thoughts?

MelM18 · 04/25/24

Ha! I was able to figure it out… It takes duration into consideration. Since the Parent 1 Tasks have a duration of 18 days and my Parent 2 Tasks have a duration of 24 days, they are weighted differently.

MelM18 · 04/25/24

Ha! I was able to figure it out… It takes duration into consideration. Since the Parent 1 Tasks have a duration of 18 days and my Parent 2 Tasks have a duration of 24 days, they are weighted differently.

Andrée Starå · 04/26/24

https://community.smartsheet.com/discussion/comment/433152#Comment_433152

Hi,

I hope you're well and safe!

Excellent! Glad you got it working!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

% Complete is Incorrect

Best Answer

Answers

Help Article Resources

Categories