nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculated field from two other fields' values

Jure Jerebic

Hi everyone,

We have a requirement to take two fields' values (Urgency and Impact), both of which have levels 1-4 that can be selected, and calculate the average of those two into a third field (Priority). This has to happen either when an issue (of a particular request type) is created or when the Impact field is updated. How can we configure this automation most effectively?

Thanks!

Accepted answers

All comments

Dexter de Vera

Hi @Jure Jerebic ,

Welcome to the Atlassian community,

You can follow this sample automation:

Trigger: Field value changed - impact

Condition:

If or Else Add condition option:

If block:

Add condition -

Issue field condition - Impact equals 1

Issue field condition - Urgency equals 1

Action: Edit field - Priority - low

Add else (If else)

follow the condition and action then change the value

So on and so forth until you align all the condition and value.

You can check this list of documentation to learn more about creating and configuring Jira cloud automation.

https://support.atlassian.com/cloud-automation/docs/create-and-configure-jira-automation-rules/

Hope it helps.

Thank you

Nikola Perisic

Welcome to the community @Jure Jerebic

First you need to identify the IDs' for both of the custom fields that have been created. You would need to create the automation rule when the issue gets created for the specific issue type (unless this applies to all of the issue types).

For the action you would need edit issue and to select the Priority field - make sure that this field is different from the already existing system field - my suggestion give it a different name.

Basic calculation: {{issue.customfield_10486}} + {{issue.customfield_10487}}

Since you need average, do the addition of two custom fields then depracte it with 2.

Nikola Perisic

Hi @Dexter de Vera , @Jure Jerebic is looking for calculating two fields,not just the automation set up.

Jure Jerebic

Nikola is correct, I don't want to set up a whole line of all the possible calculations through conditions

Dexter de Vera

@Nikola Perisic Alright. On my own understanding based on the description of this question, I think his looking for a condition based on the value selected in the dropdown list (Urgent and Impact) and then select the appropriate Priority. But yes, you can explain to him based on what you understand. Thanks!

Jure Jerebic

What would I set as the trigger? I need this to run whenever an issue of that request type is created or the Impact value is updated

Nikola Perisic

You can use only one of the triggers:

Issue created - when the issue is created the automation rule will run
Field value change - here you define when the field value change is happening for Impact then do the action

Jure Jerebic

That's what I thought as well, so I'll have to create two automations. Thanks!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management