Forum Discussion

Bhaskar mandal's avatar
Bhaskar mandal
Copper Contributor
May 29, 2018

SharePoint Calculated field based on the choice columns

Hello,

 

I have a couple of fields on the SharePoint list with two choice fields as shown below-

1-Priority (1-High, 2-Medium, 3-Low)

2-Impact (1-High, 2-Medium, 3-Low)

I would like to have a calculated field which determines a value based on the user input and calculates a number as shown below-

Calculated field = ((20% *Priority(1) + 15%*Impact(2))

whereby (1) =Priority -user selected value 1-High

(2) =Impact -user selected value 2-Medium

 

Please advise, if in any way this can be achieved?

Thanks for your suggestions.

SharePoint Online
  • Matt Coats's avatar
    Matt Coats
    Steel Contributor
    May 29, 2018

    This looks like a job for a series of IF statements. Test out your formula in an Excel table first--once you get that debugged (SharePoint is a terrible platform for testing formulas, so I don't recommend starting there), change your field names to match SharePoint's field naming convention and your field should work.

    • Bhaskar mandal's avatar
      Bhaskar mandal
      Copper Contributor
      May 29, 2018

      Thanks, Matt, that's exactly what I did, excel formulas :).  I used a simple formula with LEFT() function to address this issue.

       

      Cheers.

Resources