% Complete column not computing
My project row «SCC Project Name» is the parent row (hierarchy level 1). The phases under it are indented as child rows (hierarchy level 2). Phases= Initiating, planning, executing, closing.
The % complete is not computing on the main project row (22). It also will not allow me to enter a formula. They are not locked columns.
Please help!
Answers
-
Hello @Nikki G
The reason why the % complete is not computing is that Row 22 is currently a child row of the summary and not a parent row to Initiating, Planning, etc.
If you want Row 22 to automatically calculate the % complete based on the % complete values of Initiating, Planning, etc., it must be set as the parent row to Rows 23 onwards.
Please see the attached screenshot for reference. Hope this helps
che🙂
-
Thank you!!
Is this correct? Now the main project row (23) is outdented as hierarchy 1 and the subsequent phases Initiating, planning, etc., are indented. Please review the WBS# column. Is this correct?
Appreciate your time and help!
-
On this example, 29% overall completion for the four phases doesn't seem correct. Shouldn't it be 50% (49.75%)?
-
The Portfolio Dashboard has the active projects incorrect now that I've changed the hierarchy. :(
-
I like your take on that!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.6K Get Help
- 472 Global Discussions
- 200 Use Cases
- 513 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!