I currently have a list where there is a column "Rating" that has values of:

  • low
  • medium
  • high

and effectively I am wanting to have another column labelled "Score" fill in based on these values so for example when a list item is created with Rating of Medium I would need the Score to fill in 40-75 -- is this possible?

Have not used SharePoint in a long time so diving back in here and most I am finding is around visual and flows which I am not familiar with.

  • Do you want to make "Score" field editable from list forms after populating value based on Rating column? Nov 2, 2021 at 4:38

1 Answer 1


You can create a Calculated column named "Score" and use the below Formula:


Note:[Rating] is a Choice column

enter image description here

enter image description here

  • This was exactly what I needed :) thanks so much Echo! Nov 3, 2021 at 19:33
  • Hi Craig Phoenix. I'm glad to hear that your problem has been solved. Nov 4, 2021 at 1:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.