Sign in to join the conversation:
There is an Task hierarchy created with the layer of 5 Main sub task.
For this 5 layer Sub task Duration calculation is wrong when i tried with dependency and without dependency
Can any one help me on this
Hi Sara,
It looks and probably is correct. Check your Project Settings > Working Days so that is set up the way that you want.
The Start Date for a Parent will be automatically set to the earliest Start Date from all of its Child Rows. Similarly the End Date will be set to the last End Date from all its Child Rows.
The Duration on the Parent reflects the number of working days between the Start Date and End Date in that row. It provides the full time span encompassed by that section of tasks, from the earliest sub-task to the latest, as opposed to a sum of their durations.
The % Complete on the Parent row will calculate a weighted percentage based on both the Duration and % Complete entered on each child row. In this way, completing child rows with shorter durations won’t affect the Parent row % Complete as much as completing a longer duration child row. Because of the way this is calculated, only sub-tasks with a given Duration and a given % Complete value will be included in the parent row roll-up.
More info: https://help.smartsheet.com/articles/765753-parent-rollup-functionality
I hope this helps you!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…