% Complete Based on Amount of Tasks, Not Time

Stephen Walker

Hi, 

 

New to Smartsheet, and wondering if there is a way to have the % complete cell calculated by the number of 'child' tasks only, rather than basing it on the amount of time each task takes to complete.  

For example, if I had 5 'child' tasks below 1 parent task, I want each one to be weighted equally at 20%, regardless of how long each child task takes to complete. 

Thanks for the help!

Earl Bennett

This may be a bit simplistic, but it may work for you or get a conversation started.

 

Task Started

=COUNTIF([% Complete]1:[% Complete]33, >0) / COUNT([% Complete]1:[% Complete]33)

Task Complete

=COUNTIF([% Complete]1:[% Complete]33, =1) / COUNT([% Complete]1:[% Complete]33)

 

see attached screenshot for reference.

Earl Bennett

Alternatively, you could simply add two columns and identify if the line is a task and if that task is complete.

Identify if task row

=IF(COUNT(CHILDREN([Task Name]3)) = 0, 1, 0)

Is the task complete

=IF([% Complete]5 = 1, 1, 0)

Sum the number of Tasks on parent row

=SUM(CHILDREN())