Auto populate % Completion based on status

Plezzel Marketing

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%

Thanks

Rachael

Kelly Moore

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)))))))

Kelly Moore

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)))))))

Plezzel Marketing

Perfect thanks very much