Forum Discussion

Wiborg23's avatar
Wiborg23
Copper Contributor
Oct 17, 2022

SharePoint list inspiration for automatic text column

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

Lists

1 Reply

  • SvenSieverding's avatar
    SvenSieverding
    Bronze Contributor
    Oct 17, 2022

    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")
      )
     )
 )