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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks so much, Genevieve! I appreciate it.
-
No problem! 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!