Formula that updates % Complete based on Status
I need a formula that updates the "Percent Complete" column based on the "Crossing Agreement Status" column.
Owner Not Identified = 0%
Owner Identified = 25%
Owner Contacted = 50%
Owner Deferred = 50%
Agreement in Negotiations = 75%
Agreement Executed = 100%
Example: If the crossing agreement status is marked as owner contacted the percent complete should automatically update to 50%.
Help Article Resources
Check out the Formula Handbook template!