Welcome!

Percentage complete issues

Hi have a project plan built out in smartsheet.

The plan has a hierarchy of tasks:

Parent (core deliverable)

Child (task)

Region

When using the percentage complete option, if I add the current completed within the region columns the calculation is incorrect, it will display 0% in the parent line until all companies within the region display 100%. Hard to explain so have added a screenshot as an example.

My question is how I make this accurate with the current setup.

Thanks in advance.

Screenshot 2019-01-09 at 13.38.46.png

Find more posts tagged with

Comments

Andrée Starå

Hi Nick,

What formulas are using for those cells?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

nick.smithn15

Hi Andree,

It looks like it's using '=% Complete column, =avg(children())

I set the percentage complete up via the project settings, I've done nothing else.

I will share with you a watered down/generic project plan which has elements of the original. One parent task, the percentage complete seems to be calculating fine which is odd!

Nick

Lauren B

Do you have all of your Start Date/End Date and resulting Duration values populated? See screenshots

ss testing2.PNG

SS testing.PNG

Sign in to join the conversation!

Quick Links

Trending discussions

Automation to add links in a column in origin sheet from destination sheet.
Hi, I set up an automation to copy a row from someone's intake sheet when they assigned it to my team into my intake sheet. We did this so we didn't miss any of the metadata they are capturing. Can I set up an automation that copies a column that has "DAM Link(s)" from my intake sheet back into the original intake sheet…
Prevent an automation if a cell is blank
Hi, how can I prevent to trigger if I have a blank cell in a specific column and inform the user that the automation did not work because the cell should not be blank ? Thanks in advance Fodil
Save as New Issue
Hello, I'm encountering an issue when attempting to copy certain Smartsheet sheets. When I try to "Save As New," the process consistently times out, indicated by a spinning cogwheel. On occasion, I also receive an error message stating that Smartsheet is unavailable. This problem is not affecting all of my sheets, only a…