Hello,
For a project I need to create a column in a sharepoint list that contains a conditional/calculated column. This column is the risk value will be "calculated" depending on the values of the risk likelihood and risk consequence. Right now it is a field that users can fill in themselves but they should follow a certain logic.
I have created a seperate sharepoint list "Risk Consequence Calculator" that contains all the values that can be possible for all three columns.
The source sharepoint list is called the "Risk Consequence Calculator"
The sharepoint list where the calculated/conditional column should be filled in is "Info Sec and IT Risk Register"
The "Source sharepoint list" that contains all the data:
The list where the users can fill in the data and the risk value should be calculated:
Does anybody know how the code for the column "Risk Value" should look like?
In my humble opinion I think the logic should be like this:
If the value of Info Sec and IT Risk Register. Risk Likelihood = Risk Consequence Calculator.Risk Likelihood
and the value of Info Sec and IT Risk Register. Risk Consequence = Risk Consequence Calculator.Risk Consequence,
Info Sec and IT Risk Register.Risk value = Risk Consequence Calculator.Risk value.
Best regards,
Kris
