Convert TEXT to % for projects

Técnica Engenharia

I would like to make a formula for calculating percentages based on the progress of the task as we contract projects.

When you set the option "completed" the formula passes the value of 100%.

When "in progress" the formula goes to 10%

When status is "stopped" the formula goes to 0%

COMPLETED = 100%

PROGRESS = 10%

STOP = 10%

Andrée Starå

Hi,

Try something like this.

(remember to format the column showing the percentage with the Percentage Format)

=IF(Status@row = "COMPLETED"; 1; IF(Status@row = "PROGRESS"; 0,1; IF(Status@row = "STOP"; 0; "")))

The same version but with the below changes for your and others convenience.

=IF(Status@row = "COMPLETED", 1, IF(Status@row = "PROGRESS", 0.1, IF(Status@row = "STOP", 0, "")))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic day and let me know if you have any questions!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD