Forum Discussion

KarisiaW's avatar
KarisiaW
Copper Contributor
Apr 21, 2022

% completed depending on entered status

Hi all,

 

I want my percentage completed to be automatically adjusted depending on the status.

I have created a dropdown column "status" and based on subsequent statuses the percentage completed should be automatically adjusted.

 

To start > 0%
In draft > 25%
Internal review > 40%
External review > 50%
In revision > 75%.
In approval > 90%.
Approved > 100%

 

So I'm looking for a formula that I can put after the % completed column, I guess.


Thank you!

Kind regards!

 

Karisia 

Project

1 Reply

  • John-project's avatar
    John-project
    Silver Contributor
    Apr 21, 2022

    Karisia,
    Sorry but you can't do a custom field formula for a built-in field such as the % Complete field.

    Your "status" column appears to apply to a single all-encompassing task. It appears you's making a routine process more difficult. If instead you create a flow of tasks (e.g. start milestone, create draft, perform internal review, etc.), then it becomes a simple matter of taking credit as each major element is completed.

     

    If the above suggestion doesn't work for you then perhaps a more detailed explanation of exactly what you are trying to accomplish will help us help you.

    John

Resources