Disable Dependencies  Use weighed Formula on % Complete
Good Evening
I am wondering if something could possibly tell me what is wrong with the following. I need to disable dependencies on my Network Project Plan. I met with the pro desk, and we test using the following formula and helper column. It appeared to be working but I think we might have tested it with dependencies still enabled.
I am using the Percent Complete Helper formula and I created a % New Percent Column and used the =IFERROR(AVGW formula below but once I disabled the dependencies it doesn't roll up to the parent rows a weighed % complete.
Answers

Hi @Lori Khoury
It looks like your formula is outputting 0 because of the IFERROR function wrapped around it. When you take away the IFERROR, and just do the AVGW, what is the error you're receiving?
If you see a "Divide by 0" error, this means that some of the Child rows below may not have a Duration, which then would roll up into an error. Keep in mind that since you have multiple levels of hierarchy, if one of your Parent level returns an error, then this will bubble up to any parent rows looking at it as well:
Since my duration cells are empty, my Child 3 with the weighted formula is an error  this means that the Project level Parent also errors, which causes the overall, toplevel to error.
As soon as I have values in the duration cells and in the % Complete cells, the formulas calculate correctly:
If the % Complete is blank for all the Child Rows, I get the same error, which again, bubbles up through all my related Parents:
This is because the CHILDREN() part of your formula will = 0.
Is it possible you have a section in your sheet with either blank durations or blank % Complete cells?
I hope this helps!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 378 Global Discussions
 208 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!