Group not totaling correctly

bhardin

I have groups and sub-groups (I hope I'm using the right terminology, I have 8-rows indented under another row) and only the first four rows are totaling.  The calculation is for Duration and I am using days and hours.   

Isaac Jose

Hello bhardin,

Regarding the terminology, I believe the terms you are looking for are Parent Rows and Child Rows. Information about using Hierarchy can be found here:

• Hierarchy: https://help.smartsheet.com/articles/504734-hierarchy-indenting-outdenting-rows

Regarding the calculation issue, it appears that you've enabled Dependencies, however the calculation only appears to be calculating about two hours rather than eight hours. Have you entered predecessors in your Predecessors column? If predecessors have not been entered, Smartsheet will assume that your tasks are being worked on simultaneously rather than in sequence. Additionally, the Duration shown in the parent row is based off of the Start Date of the first task and the End Date of the last task, not necessarily the sum of the Duration of the child rows.

To resolve your specific issue, in your Predecessors column starting with row 11, try entering the previous row as the predecessor to the current row. More information on this below:

• Enable Dependencies and Use: Predecessors https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors
• Project Sheet Columns: https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors
• Modify Project Settings: https://help.smartsheet.com/articles/765755-modifying-project-settings