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; } } }

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

stephan.lewis

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?

Accepted answers

Walter Buggenhout

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!

All comments

Walter Buggenhout

Hi @stephan_lewis,

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!

stephan.lewis

ohh - never used Lookup tables

I will check it out

Thank you so much!

stephan.lewis

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

John Funk

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.

stephan.lewis

John Funk

Thank you!

Bachir AMMACHE

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 ,

stephan.lewis

Did you create a Risk Score custom field?

Maksym Babenko_TypeSwitch_

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!

Marco van Vliet

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.

Rasmus Ersmarker

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

kh-samyak

@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!

kh-samyak

@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!

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

smartsheet