SharePoint list inspiration for automatic text column

Copper Contributor

Hi, 
I have a need to build a Risk input for a SharePoint list that I need some assistance or inspiration with.

 

Task is to create a Risk input (a column text value of LOW, MED or HIGH) by having the user select a Likelihood (text value in a column) and a Consequence (text value in a column), which then automatically sets the Risk input. 
For example the user selects "Likely" in the Likelihood and Moderate in the Consequence, then the Risk is set to "HIGH" by the system.
I can make this work in excel, but having issues finding a good approach for a SharePoint list. 
Should I be looking at specific formulas or can this be done through the Power app form for the list?
I have also considered if I could insert the Risk matrix as a picture in the power app form and make the various combinations as clickable buttons that then sets the Risk value in the list. 

 

Looking forward to your inputs and inspirations.

 

Allan

1 Reply

@Wiborg23 
You could setup three columns


Likellihood as Choice 
Consequence as Choice
Risk as a Calculated Colum


Then as a formula for the calculated column use something like

=IF(
     AND(Likellihood="Likely",[Consequence]="High"),"HIGH",
     IF(AND(Likellihood="Unlikely",[Consequence]="High"),"HIGH",
      IF(AND(Likellihood="Likely",[Consequence]="Low"),"LOW",
        IF(AND(Likellihood="Unlikely",[Consequence]="Low"),"LOW","DEFAULT")
      )
     )
 )