Change the % Complete to 100% if Status is Completed

Cayla Davis

I am trying to get my project plan to change the % Complete to 100% if Status is Completed, does anyone know how to do this? I already have a formula around Task Health, and im trying to incorporate this into the change the % Complete to 100% if Status is Completed

Anyone know how to accomplish this?

=IF(Status@row = "Complete", "Blue", IF(Status@row = "Not Started", "Red", IF(Status@row = "In Progress", "Green", IF(Status@row = "Risk", "Yellow"))))

Gillian C

Hi @Cayla Davis

The screenshot above would suggest that you want to manually update the % Complete column when the work is in progress. But you are also asking for it to automatically update to 100% when the Status changes to Complete?

If the above is the case then I think you could have two options.

Option 1: Create an automation similar to this one

Option 2: Create a helper column called Progress where the progress can be manually updated, and then in your % Complete column have the following formula

=IF(Status@row = "Complete", 1, IF(Status@row = "Not Started", 0, Progress@row))

*for both options it is assuming the % Complete column is formatted to %.

Hope that helps?

David011

1. Change the column type: Ensure your % Complete column is set to a percentage format. You can do this by highlighting the column and selecting the % icon in the left-hand menu.
2. Add the formula: You can use the following formula to automatically set % Complete to 100% when the Status is "Completed":

=IF(Status@row = "Completed", 1)

I hope this helps!

Cayla Davis

Hmm, it doesnt work well with a project plan

Gillian C

Hi @Cayla Davis

The screenshot above would suggest that you want to manually update the % Complete column when the work is in progress. But you are also asking for it to automatically update to 100% when the Status changes to Complete?

If the above is the case then I think you could have two options.

Option 1: Create an automation similar to this one

Option 2: Create a helper column called Progress where the progress can be manually updated, and then in your % Complete column have the following formula

=IF(Status@row = "Complete", 1, IF(Status@row = "Not Started", 0, Progress@row))

*for both options it is assuming the % Complete column is formatted to %.

Hope that helps?

Cayla Davis

Thank you @Gillian C - thats a great idea on Option 1, i never thought of that! appreciate it!

Gillian C

You're welcome :) @Cayla Davis