Overall Average Percent Compete

I'm going to suggest creating a hidden helper column (we'll call it "Helper" for this example).

In each of the parent rows of the helper column use 

=ROUND(IF(COUNTIF(CHILDREN([Complete?]@row), 1) / COUNT(CHILDREN([Complete?]@row)) > 0, COUNTIF(CHILDREN([Complete?]@row), 1) / COUNT(CHILDREN([Complete?]@row)), 0) * 100, 0)

This will give you the NUMBER. In the [Complete?] column, you can enter

=Helper@row + "%"

This will combine your number with the percent sign.

For the overall row you would enter into the Helper column

=ROUND(AVG(CHILDREN()), 0)

=(COUNTIF(CHILDREN([Complete?]@row), 1) / COUNT(CHILDREN([Complete?]@row))) * 100

Try the above. I took out the extras (for now) of rounding and whatnot. That should give you a number and possibly a few decimal places. If that works then you can wrap it in your ROUND function like so...

=ROUND((COUNTIF(CHILDREN([Complete?]@row), 1) / COUNT(CHILDREN([Complete?]@row))) * 100, 0)

Look here at the project sheet and the %Complete on how you could use the automatic functions in Smartsheet.

https://app.smartsheet.com/b/publish?EQBCT=63979e622cc14da2a4b938194d31…

Would that work?

Best,

Andrée

Ok. Create a text/number Helper column (called "Helper"). In that column put this formula in all of your green rows.

=ROUND(IF(COUNTIF(CHILDREN(Complete@row), 1) / COUNT(CHILDREN(Complete@row)) > 0, COUNTIF(CHILDREN(Complete@row), 1) / COUNT(CHILDREN(Complete@row)), 0) * 100, 0)

Then in the Blue row of that column, put this.

=ROUND(AVG(CHILDREN()), 0)

In your Complete column, put this in the green rows and the blue row.

=Helper@row + "%"

You can then hide your helper column to keep your sheet looking clean.

Yes, that will not work because it has to be a number/text column. You'll have to do it the way Paul suggested if you must have the checkboxes.

Best,

Andrée