How to Fix: Value of Parent Row (days) Not Showing the Sum of the Childrens' Rows (days)
We may have run into a bug with a value on a parent row. The duration of days should be 15 days because the sum of the childrens' rows is 15 (5 tasks, 3 days each), but the parent row displays 25 days. Where could this be pulling from?
Can anyone provide some direction?
See Row 18 in the attached screenshot.
Thanks!
Des
Best Answer
-
Thanks so much, Genevieve! I appreciate it.
Answers
-
Hi @Des
The Parent Rollup Functionality takes the first/earliest Child Row Start Date and the last/latest Child Row End Date in order to give you an overview of how long all of the children tasks will take from start to finish.
Your first Start Date is 01/03/23 on row 22, and your last End Date is 02/06/23 on row 21. Therefore, the working day duration for the Parent row is 25d! Does that make sense?
See: Parent Rollup Functionality
Cheers,
Genevieve
-
Thanks so much, Genevieve! I appreciate it.
-
No problem! 🙂
Help Article Resources
Categories
Check out the Formula Handbook template!