Proportion of % Complete

Options
✭✭✭✭

Hi,

I have a question. Under the % complete, I completed 4 tasks under Parent Row Location, however on the row of Location, it still showed 0% complete. It seems it won't automatically adjust the level of % of completion. Do you know what's wrong with that? I did set the formula in the completion Progress column: =IF([% Complete]7 < 0.25, "Empty", IF([% Complete]7 < 0.5, "Quarter", IF([% Complete]7 < 0.75, "Half", IF([% Complete]7 < 1, "Three Quarter", IF([% Complete]7 = 1, "Full"))))). However, I don't know if it will affect the result on the % complete column. Please advise. Thanks!

• ✭✭✭✭✭✭
Options

Hi @AAL,

You can adjust the formula to do all rows quite easily:

=IF([% Complete]@row < 0.25, "Empty", IF([% Complete]@row < 0.5, "Quarter", IF([% Complete]@row < 0.75, "Half", IF([% Complete]@row < 1, "Three Quarter", IF([% Complete]@row = 1, "Full")))))

You can then use this as a column formula (right click on the cell to do this).

However, you'll still need the % Complete to be updated. For the tasks, this is presumably done manually, but for the parent rows you can do it with a formula - assuming the tasks are equal in terms of weighting. If so, then this formula should work:

=AVG(CHILDREN([% Complete]@row))

Using similar data to yours, this would give a result like this:

Hope this helps, but if there is anything else then just post! 😊

• ✭✭✭✭
Options

Thank You Nick for your prompt response.

• ✭✭✭✭✭✭
edited 06/21/23
Options

I believe this was also already answered in another thread. You need to enter the End Dates since you are using dependencies.

https://community.smartsheet.com/discussion/comment/381469#Comment_381469

• ✭✭✭✭
Options

Thank you, Paul.