Is it possible to create a SharePoint column based on choice (definition) that when selected populates the rating on another column?

I will need to add sum of all scores:

enter image description here

Thanks a million!

  • Do you want to store multiple definitions for each question? or you will be adding multiple list items for each definition? Nov 2, 2020 at 12:37
  • yes the defintions will be stored. For example, on number 1, there will be three definitions.
    – Jose1978
    Nov 2, 2020 at 12:40
  • on secodn question, the definitions are: Minimal Moderate Significant. Ratings always 0-3-9
    – Jose1978
    Nov 2, 2020 at 12:42

1 Answer 1


If you want to auto-populate values in Rating, you can create the Rating column as a calculated column, and then use the IF function to return values.

Here is a sample formula for your reference:

=IF([Definition]="1-200 people", 0,
    IF([Definition]="201-800 people",3,
        IF([Definition]="> 800 people",9,""

enter image description here

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.