How to find the percentage complete for a project

Hi guys,

I want to know the percentage complete for my project.

I have 10 tasks below my parent. If 3 of the tasks are checked, I want the parent to say 30% completed.

I am using the formula below to find out how many of the boxes are checked. I could replace the 1 with a 0 to find out the number unchecked. I could do a count children and then do count if checked/countchildren*100, but I would need to store all these values in a separate field.

Is there a simpler way to do this?

=COUNTIF(CHILDREN(), 1) + ""

Find more posts tagged with

Finance

Comments

mclarenfan

found the answer in here

https://community.smartsheet.com/discussion/create-percentage-complete-based-boxes-checked

Atus Bartal

Try this:

=COUNTIF(CHILDREN(CheckboxColumn1), 1) / COUNT(CHILDREN(CheckboxColumn1))

And set the format of the cell(s) to "%" on the left toolbar.

(in this case CheckboxColumn is the name of the column where the checkboxes are, the parent row is the 1st one. It did work for me.)

atus