% complete using checkboxes

Options
Shane Sorensen
Shane Sorensen ✭✭✭✭
edited 01/27/21 in Formulas and Functions

Is there a formula or function that will count up the # of children checked off and report the total % checked in the parent row?

As an example, I have two out of six activities (children) checked off, which means the parent work package is 33.33% complete. I would like the parent checkbox to report the 33.33% and update automatically as more activities are checked off.

Or, if there a better/another way to capture progress as activities (children) are completed and reported in the parent row, that would be useful! Thank you!


Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓
    Options

    Try adding this formula to your parent row:

    =ROUND(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()), 2) * 100 + "%"

    I added the "%" because it will convert your answer to a text format which will display in the checkbox column (as long as the column settings are not restricted). Otherwise a number can't be displayed.

    This basically did the math and rounded it to two decimal points.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!