Auto populate % Completion based on status


hi gang,

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

Planning 10%

Build 25%

Internal Review 35%

External Review 45%

Scheduled 65%

Live 75%

Completed 100%



Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    This formula would go in the % Complete column

    =IF(Status@row<>"", IF(Status@row="Planning", 0.1, IF(Status@row="Build", 0.25, IF(Status@row="Internal Review", 0.35, IF(Status@row="External Review", 0.45, IF(Status@row="Scheduled", 0.65, IF(Status@row="Live", 0.75, 1)))))))