Automation Help: Update Percent Complete (custom field) based on Issue Status

[sgover]

I have a custom field for Percent Complete. This is a single picker field with a few simple numerical values to choose from.

The team wants the Percent Complete field to be automatically updated when the status of the issue is changed. Here are the business rules:

• If Status is 'New' then 0%
• If Status is 'In Draft' then 25%
• If Status is 'In Review' then 60%
• If Status is 'In SignOff' then 80%
• If Status is 'Rework' then 60%
• If Status is 'Complete' then 100%

Can you help me identify what's wrong with this Automation? It doesn't seem to be working. Here's what I currently have running (which doesn't seem to do anything at all).

[Bill Sheboy]

Hi @sgover 

As written, your rule is stopping as soon as the first condition is not met.

For your scenario, there are two solutions:

• use the if / else condition block, testing for each value, making the rule around a dozen steps
• a better approach is to use a Lookup Table to map the Status's name values to the Percent Complete value; this would simplify maintenance of your rule and reduce it to 3-4 steps

Kind regards,
Bill

[Tim Perrault]

Lookup Table probably the better way to go. Thanks @Bill Sheboy 

[Tim Perrault]

Hi @sgover 

What does the audit log for the rule say?

[sgover]

No Actions Performed

[Tim Perrault]

When you click on the show more button on the audit log does it have anything extra?

What status is currently giving you issues? Is it on every transition?

[sgover]

I've tried several combinations with various issue types, but it doesn't seem to work at all. I'm getting the following result in the audit log.

[Tim Perrault]

What if you tried using the IF or ELSE condition instead of using issue fields condition?