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:
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
Hello, smarter friends: I'm trying to learn how to utilize automations to move certain rows to new sheets in order to explore if my larger/longer ranging goal is possible. Where I'm Currently Stuck: I can't even figure out how to create functional auto to send a row to a basic sheet. That is my immediate need. But if…
I'm having issues accessing Smartsheet in both the desktop app and web browser and continually get the below error message…I need to refresh multiple times to get it to work. And sometimes it works and sometimes it doesnt:
This just started today… For some reason, I can no longer edit fields in my Smartsheet. One I'm the owner of. I do see an icon in the upper right that says "Comment Only", but can't figure out how to change it. Here a screenshot of what I am seeing:
