How to Fix: Value of Parent Row (days) Not Showing the Sum of the Childrens' Rows (days)

DesDes
edited 10/19/21 in Formulas and Functions
10/19/21 Edited 10/19/21
Accepted

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

  • DesDes
    Accepted 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

  • DesDes
    Accepted Answer

    Thanks so much, Genevieve! I appreciate it.

  • No problem! 🙂

Sign In or Register to comment.