Forum Discussion

leecoogan's avatar
leecoogan
Copper Contributor
Apr 13, 2023
Solved

SharePoint List - Calculated formula

Hi I am trying to import my risk register to a SharePoint list and need a formula that looks at columns based on their PESTLE analysis to assign it a 'Low, Medium or High' score.   My formula base...
Lists
microsoft lists
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Apr 13, 2023

    leecoogan Try using this formula: 

     

    =IF([PESTLE]="Political","High",IF(OR([PESTLE]="Economic",[PESTLE]="Sociological",[PESTLE]="Technological"),"Medium",IF(OR([PESTLE]="Legal",[PESTLE]="Enviromental"),"Low","")))

     

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

ganeshsanap's avatar
ganeshsanap
MVP
Apr 13, 2023

leecoogan Try using this formula: 

 

=IF([PESTLE]="Political","High",IF(OR([PESTLE]="Economic",[PESTLE]="Sociological",[PESTLE]="Technological"),"Medium",IF(OR([PESTLE]="Legal",[PESTLE]="Enviromental"),"Low","")))

 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Resources