How is percentage completed added?

Robert_Holt

I want to update a Gantt chart that has been neglected. Several tasks have been completed. How/where can I add data to show the work has bee completed?

Ray Lindstrom

@Robert_Holt,

You would typically update a tasks "% Complete" column to 100%.

Andrée Starå

Hi @Robert_Holt

I hope you're well and safe!

There's an automated way.

https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors#toc--complete

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Raniel

Morning,

Is there a step by step video that can guide me on how to apply % when a project is completed.

Thank you in advance

Genevieve P.

Hi @Raniel

You could use a Change Cell Workflow to add a value to your % Complete column when another cell changes (for example when the Status changes to "Complete"), like so:

See: Change the value of a cell in an automated workflow

Keep in mind that if you're using a Project Sheet with Dependencies enabled, this will only update child row cells, since the Parent Row % Complete is based off of the Child % Complete. See: Parent rollup functionality

Cheers,

Genevieve

Raniel

Hi Genevieve,

Thank you so much for sharing this, I was able to follow your instruction automation was set but the number under % even if I change the status to "complete" % remain at the same number and has not change to 100%.

Appreciate your help please :)

Before

After

Andrée Starå

Hi @Raniel

I hope you're well and safe!

Can you share some screenshots of the Workflow? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Raniel

Happy Monday Andree,

Please see the below screenshot.

Also, my sheet doesn't have dependencies, no column added.

Genevieve P.

Hey @Raniel

Is it possible your sheet wasn't saved when the change was made?

I can see in your image that the save button has not been clicked.

The workflow will only be triggered once the change is saved to the sheet, and it can take a few minutes for it to come through. Can you try changing another cell, saving the sheet, then waiting to see if it updates?

Let me know if that was the cause!

Cheers,

Genevieve

Andrée Starå

@Raniel

Thanks, and likewise!

Everything looks correct, so the issue is probably timing, as Genevieve suggested.

Was that the issue?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Raniel

Hello @Genevieve P. & @Andrée Starå

Appreciate your help and sorry to be a pain! ;P

I tried but the % remain on same number and didn't change to 100.

Robert_Holt

Hi

I must be missing something absolutely basic, but when I try and add a column I only get a fixed list to choose from and none of them are "% completed".

Also I cannot see how to reply to anyone who has tried to assist me in this community page. Can anyone supply an email address? I have had 10 responses, but not had any joy.... Robert

Genevieve P.

@Raniel - in the newest image it still looks like the "Save" hasn't been clicked. Now that it's been some time, has your sheet Saved and the value updated?

Genevieve P.

@Robert_Holt - @mentioning users in the Community will notify them of your response 🙂

How is the column currently being populated? Do you have a Column Formula in it?

Raniel

@Genevieve P. hi thanks for the reply. Yes, I did click save, just wanted to show in my screenshot that the save button was available at the time when i changed the status to complete.

Raniel

I manually changed item 7 to 100% as the project completed already.

Please see item 8, change status to complete, click save but still in 65% instead of 100%

Thank you for looking into it or perhaps if there is a step by step video that I can watch? please share it.