Forum Discussion

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...

Lists

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