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:
Hi All, I have a sheet that I am creating to gather powder coat thickness data. The problem I have run into is that they can do up to 5 checks on the same line during the same day and shift. Then they get the average of those measurements to use for the day to determine if the thickness passed or failed. If I have a form…
Hi All, Need you support for the the issue. I was in the process of making an approval workflow for petty cash request, the problem was when i want to combine 2 different confirmation workflow by Requester to be appear in same column (Confirm), but mention notification like in the screenshot attached. The workflow consist…
A report is not available to be a data source for a Metric Widget. I have a report that shows the one figure I want to be displayed on a dashboard. I cannot convert the report to a sheet and cannot seem to get the report number on my report to the Metric Widget… Can this functionality be added to use a report for a data…
