% Complete Based on Amount of Tasks, Not Time



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!


  • 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.

    Screen Shot 2018-02-24 at 7.28.20 PM.jpg

  • 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


    Screen Shot 2018-02-25 at 7.46.29 AM.jpg

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!