Calculate Text based on two other fields

Question

I have a risk register and want a field to automatically calculate the risk rating based on consequence and likelihood. If you are able to provide examples on how to do this I can build in our risk rating matrix into the code. Thanks :)

For example:

Field 1 (Consequence) = "Moderate"

Field 2 (Likelihood) = "Possible"

Field 3 (Risk Rating) to specify based on Field 1 & 2. In this case "Medium 5"

Shane ORourke · Answer

Thanks David, I will look into it.

David Pinn_1ll7gn · Answer

Hi Shane. One approach is to write calculations in Groovy, using the ScriptRunner add-on. It's a little tricky because you need to work with custom field option ids. If you go that route, all power to you; but the alternative is to install the Risk Register add-on, of which I am the author. Wishing you every success, no matter which way you go.

David