Change the % Complete to 100% if Status is Completed

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"))))

Find more posts tagged with

Formulas

Accepted answers

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?

All comments

David011

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.
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

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.