How do I get the % Complete column to reflect the percent of Target Hours complete rather than the duration of days?
Hi @Tedd Powers
First, I interpreted the "number of hours completed against goal" as follows;
Second, I analyzed how Smartsheet calculates the % Complete when Dependencies are set as "Dependencies enabled".
Lastly, I applied the same logic to calculate [% Hour Complete].
It would have been easier if I calculated the simple average of the [% Complete] or [% Hour Completed]. Still, Smartsheet's weighted average approach gives me a more accurate completion rate, considering each completed child's relative length.
Is the "Target Hours" something different from the duration of hours?
In the example below, Parent 1 has 20 hours of work. Out of these, 50% of 8 hours is not complete, so 16 out of 20 hours are complete, so the parent %Complete shows 80%.
My structure is such that I have a Target Start Date, a Target End Date, and a Target Amount of Hours. As the project progress, I would like to track the actual start/end dates and the actual hours. I want the Complete % field to be based on the number of hours completed vs target as opposed to the number of days completed. I have included the project settings screen shot below the workplan.
Thanks so much. This was very helpful and solved my issue.
Happy to help.😁
Hello, I am currently attempting to organize my files in Workspace by creating folders to group them. I am doing this by dragging and dropping sheets from the 'Sheets' folder into my 'Workspace' folder. However, some sheets that I own and created do not appear in the 'Sheets' folder. I even tried editing some details in my…
The number of Unlicensed Users was listed previously under User Accounts. Why is it no longer there?
I have a filter set so that if this task complete box is checked, then the row is hidden. Is there a way to make it so that if the parent row is checked, then the child rows hide as well? Right now when a parent row is checked, only the parent row is hidden.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.