Community
Q&A
Jira
Questions
Is there a way to create a Risk Score based on the Probablility times the Impact of the Risk?

Is there a way to create a Risk Score based on the Probablility times the Impact of the Risk?

This gets a bit more complicated in that the Probability and Impact fields contain both Text and a Number (1- Low, 2- Low-Medium, 3 - Medium, etc.)

I wanted this all in Jira so that I could have a real time Risk Register in Confluence.

I couldn't figure out a way to do this in Jira so I tuned to Smartsheet to come up with a solution. However I need to run the Jira connector to update my sheet (yes there is supposed to be a 2 way live connector - but I've never had any success with it).

Any thoughts?

5 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

3 votes

Answer accepted

Hi @stephan_lewis,

Make sure you have 3 custom fields available in your Jira project: probability, impact and a risk score. Create an automation rule to calculate the risk score at each change of one of the other fields.

Your automation rule could use Field Value Changed as its trigger (referencing both fields). Use lookup tables to translate the options from your custom fields to numbers for your calculations.

Hope this helps!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

ohh - never used Lookup tables

I will check it out

Thank you so much!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Lookup tables are great - easy to set up.

I created two lookup tables; ProbabilityValue and ImpactValue.

The tricky part was getting the Smart Value formatting correct.

If your custom field has multiple words you need to use quotes around them.

{{ProbabilityValue.get(issue.Probability)}} * {{ImpactValue.get(issue."Impact of Risk")}}

It works great if both the Probability and Impact of Risk have values. However, if one of them is missing then it throws an error.

Edit issue: Could not convert the field value to a number. Please ensure the value is a number, math expression or smart-value that can be converted into a number.

Makes sense; can't mutiply without 2 values.

Have to put in a check for values and bail if they aren't both there. Haven't done this type of check - but hopefully it will be easy.

Thanks for your help,

Stephan

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • John Funk likes this

Hi @stephan_lewis - can you post your final rule, especially showing the details of the lookup tables? That will help future readers of the post.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

0 votes

Hi @stephan_lewisif the aim is to avoid maintaining automation rules and a Smartsheet connector, an app-owned risk field setup may be simpler.

Disclosure: I work on FastRisk, Risk Matrix & RAID Log for Jira. It provides likelihood and impact scales and writes the calculated risk score into Jira fields, so you can search it in JQL (for example, `"Risk score" >= 15`) and see risks on a matrix/register without maintaining lookup-table rules. The risks remain normal Jira issues, rather than rows in a separate system.

It is designed for practical project risk tracking, not formal regulated-compliance workflows: https://marketplace.atlassian.com/apps/1553331139/fastrisk-risk-matrix-raid-log-for-jira

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Rasmus Ersmarker
If you're part of a Marketplace App team, we would like to ask you to follow the steps outlined here to get an 'Atlassian Partner' lozenge for your profile!
Cheers!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Rasmus Ersmarker, this topic has been locked because the thread has become a bit dated. If you'd like to keep the conversation going or have additional questions, we encourage you to start a new topic. You can read more about necro posting ("raising threads from the dead") in our Community Guidelines.
Thanks!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

You can also use a set of Else-if statements. Risk Impact and Risk Likelihood in my project have the values Low, Medium and High. We do not have corresponding numbers of the values to calculate the Risk Level. So I had to use several Else-if statements.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hello @stephan_lewis

Yes, you can calculate a Risk Score in Jira by multiplying Probability and Impact values, but Jira doesn’t natively support calculated fields.

A workaround is using Risk Radar, which automatically evaluates risk based on key parameters, including Probability and Impact. It keeps everything in Jira.

Let me know if you’d like more details!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thank you!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello !

I did the same thing but it is not working for me ,
P.S : My Impact and Probability fields are only text field (dropdown values) Low , Medium, High
I did 2 lookup values but still nothing works ,

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Did you create a Risk Score custom field?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Did you create a Risk Score custom field?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Yes I did , but the thing is that my probability and impact risk are dropdown custom fields ( with icons red/orange/ green circles) and I can not add these icons to the lookup table .

The rule works well when I change the fields from dropdown to text fields , but I really need to show the emojis ...

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

oh - can you change them to number fields instead - just to see if it works?

Not sure how to address the icons.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

Was this helpful?

Thanks!

Jira

DEPLOYMENT TYPE

CLOUD

PRODUCT PLAN

PREMIUM

PERMISSIONS LEVEL

Product Admin

We're moving! The community forums are migrating to a new platform on September 22. Learn more

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Is there a way to create a Risk Score based on the Probablility times the Impact of the Risk?

5 answers

1 accepted

Comments for this post are closed

Comments for this post are closed

Was this helpful?

Thanks!

DEPLOYMENT TYPE

PRODUCT PLAN

PERMISSIONS LEVEL

TAGS

Community showcase

Atlassian Community Events