Parents Misrepresenting Start & Finish Dates of Children
I have the Parent Rollup Functionality turned on as it is essential for my project to handle to dependencies. The problem I'm trying to overcome is that the Parent displays Target Start (TS) and Target Finish (TF) dates when not all children are populated in the same fields. If child#1 (of 2) has TS and TF dates populated, and child#2 does not, the Parent will display child#1's TS and TF dates. This is a problem because without child#2's dates considered, the Parent is displaying incomplete info.
I've reached out to support and was advised that this functionality does not exist, and as such I'm curious to see if anyone has a creative workaround. Further relevant info
- In the scenario above child #2 is not populated for good reason and unavoidable,
- A solution that requires manually filling in rows as they get added will not work as there are so many involved and it's an 800+ task project
- In the screenshot example from my project the highlighted problem area is further complicating things by affecting tasks up to the great-grandparent level
I've got some great solutions in this forum when googling issues but this is my first time posting. I'm desperate!
Help Article Resources
Check out the Formula Handbook template!