Convert TEXT to % for projects
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%
Help Article Resources
Check out the Formula Handbook template!