Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Percent Calculation
Comments
-
From my quick analysis, the % Complete works on Duration complete rather than an average of the Percentage column, therefore if you have milestones in the tasks these are not included in the calculation as they are 0 days duration.
If anybody else knows different they may be able shed more light on it.
James
-
James is right.
John,
Is it a project sheet with durations, start and end dates?
It would be easier to answer if we saw the other date-related columns as well as their headers.
Thanks
Atus
-
Hi James & Atus, thanks for the quick response! It is a project sheet with durations, start and end dates.
James, can you explain the Duration complete rather than average of the percent column concept in a bit more detail?
Atus, here is another attachement.
Thanks!
-
John,
See image:
James
-
Thanks John and James!
-
All,
James is correct.
In many cases, however, this gives you bad information, at least in my world view.
In Smartsheet:
% Complete is based on sum(duration of individual tasks * % complete of indivual tasks) / sum(duration of individual tasks)
This does not change if the tasks are sequential (like in James' example) or all in parallel.
It also does not change with Allocation % (effort).
In my world view, if I have a task that requires 1 hour a week for 50 weeks (50 hours)
and 2 tasks that are 50 hours each but take 1 week each, then
In Smartsheet's view, if I finish the the hourly task, I'm 96% done (the tasks overlap)
But in effort, I've only done 33% of the work (50 hours / 150 hours)
When I deal with cost of a task, I add several columns to account for this.
Craig
-
For some reason, when I roll up the % complete, it does not reflect the true % complete. My initiation phase is 80% and Site Visit Preparedness is 13%, the aggregated % complete for Pre-Visit Task completion is only showing Site Visit Preparedness. Thoroughly confused!
-
Hi Sami,
Is the top row, Pre-Visit Task Completion, a parent? It doesn't look like it from your screenshot. It has to be if it should be automatic and you don't want to add the formulas yourself.
What formula are you using in the 13% in the top row?
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I didn;t use any formula. I thought I saw in one of the videos that you can roll up by dragging the cursor. .. Oops!
I have never used parent/ child function before. I tried it after I saw your message. and I get a message saying I can not update because the row has sub tasks. Do I need to delete the hierarchy to make it work? Is there a video that shows how parent/ child function work? I looked through youtube, but in vain.
Thank you
-
Happy to help!
You don't need to delete anything.
Here's an excellent resource: https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors
And another one: https://help.smartsheet.com/learning-track/smartsheet-advanced/gantt-chart-dependencies
Hope that helps!
Let me know if you have any questions!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives