Completion % Formula Based On Drop Down Options
Am running into a bit of difficulty attempting to input a formula in the sheet I have created. I am wanting to have the completion % column auto populate with predetermined values based on what is selected in a dropdown menu from the 'status' column, i.e., completion % automatically goes to 50% if status is 'in progress'. The completion % column currently requires manual entry and was setup from the standard predecessor/duration from project settings, which won't let me input a formula.
Considered removing the project settings for completion % and recreating a column but I do like the rollup % aspect for the various department aspects.
Help Article Resources
Check out the Formula Handbook template!