nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

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.

Find more posts tagged with

Government

Project Management

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

MOVE ROW Lost Attachments
I was archiving critical accounting data from one sheet to another by moving the rows. This is something I've done countless times in the past decade of using Smartsheet. This time, after moving nearly 3500 rows of data, I realized none of the attachments moved with the rest of the data. I've opened a case but have had…
Copy/Paste in Table View
Hi Team Is there an update on this Community post from a year go? Issues with copying in the Windows App - Table View - Smartsheet Community I have confirmed in both Desktop and Web Applications, and on multiple browsers where the Clipboard setting in "ALLOWED", but the copy/paste CTRL-C/CTRL-V is not working. It doesn't…
User not showing up to assign roles
I have a user that has accepted their invite. They do not show up in the roles section for me to assign the user roles.