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.
Sign in to join the conversation:
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.
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:
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:
Is smartsheet server is down today? I'm a user from Philippines and we cannot access smartsheet.
Anybody here gets the same problem as I do? This is happening only recently. I have set an automation enabling rows to moved or copied to another sheet. There is no set automation to lock the rows either from both source or destination sheet. But once copy or moved is triggered the rows gets automatically locked at the…
Need help please - on my timing plan, I have 100% completed but on dashboard, for which I created report (see details below of filter) is pulling only 90%. Any tips please?