Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

How to find the percentage complete for a project

Options
mclarenfan
edited 12/09/19 in Archived 2016 Posts

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) + ""

Tags:

Comments

This discussion has been closed.