Parents Misrepresenting Start & Finish Dates of Children

Chris Topher
Chris Topher ✭✭✭✭
edited 08/25/21 in Formulas and Functions

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!

image_2021-08-25_121855.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!