Auto populate % Completion based on status
I was wondering if we can do the following in Smartsheet, we only have one of the lower packages so no dashboards etc
Here is my quandary: Can we auto populate set percentages of completeness based on a status drop down?
For example when a task is in Planning it should be 10%
Currently I am manually using filters and applying the percentage manually once a week, it would be more efficient and correct if when the status changes the percentage does too automatically
Internal Review 35%
External Review 45%