Update field based on value/sum from other fields

Dag Atle Stentad

Hi Atlassian Community!

In a Jira project I have five custom fields. The fields have the same datatype; dropdown with the values Critical, serious, moderate, low and Insignificant.

Is it possible to use Jira Automate to calculate and update one of the fields (“Sum Risk”) based on the value from the others four fields.

• Critical = 5
• serious = 4
• moderate = 3
• low = 2
• Insignificant = 1

 Sum the four fields and divide by 4. Based on the result the «Sum Risk» field should be:

• Critical = 4.5 - 5
• serious = 3.5 – 4.4
• moderate = 2.5 – 3.4
•  low = 1.5 – 2.4
• Insignificant = 0 – 1.4

Thanks for tips!

Mikael Sandberg

Yes, that is possible. You can use math expressions to sum up the values for the four fields and then use if/else conditions to set the sum risk.