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

Find more posts tagged with

Templates

Sheets

Formulas

Solution Center

functionality

Accepted answers

Des

Thanks so much, Genevieve! I appreciate it.

All comments

Genevieve P.

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

Des

Thanks so much, Genevieve! I appreciate it.

Genevieve P.

No problem! 🙂

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.