Forum Discussion
Wiborg23
Oct 17, 2022Copper Contributor
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...
SvenSieverding
Oct 17, 2022Bronze Contributor
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")
)
)
)