2

I am seeking for help with SharePoint online list, where I have choice columns with following answer choices: 1,2,3,4,5 where each choice has own value e.g.

  • 1 = 30 points
  • 2 = 60 points
  • 3 = 90 points
  • 4 = 120 points
  • 5 = 150 points

How do I write the formula for calculated column (new column) to show the right value for selected choice?

4
  • If my answer did help you out, please also mark it as an Accepted Answer. Thanks! May 30, 2023 at 10:13
  • Are you using multiple choice columns like this? What do you mean by "calculate overall score based on columns values"? Are you trying get total points based on single choice column or based on multiple choice columns? May 30, 2023 at 13:15
  • Did you try using below formula? Is it working for you? Jun 1, 2023 at 8:15
  • Have you tried the method below? Does it meet your requirements? Jun 8, 2023 at 6:18

2 Answers 2

2

Use this calculated formula, assuming Choice is your column name

=Choice*30

If you need the " points" appended,

=CONCATENATE((Choice*30)," points")

enter image description here

1

Extending answer by @thebernardlim further,

If you have multiple choice columns with the choices like: 1,2,3,4,5 and you want to get the overall score (your question title mentions it) based on these columns values (SUM), you can use formula like below for your calculated column:

=CONCATENATE([Choice1]*30 + [Choice2]*30 + [Choice3]*30," points")

Sometimes, you may need to explicitly convert number choice options to actual number value using VALUE() function like:

=CONCATENATE(VALUE([Choice1])*30 + VALUE([Choice2])*30 + VALUE([Choice3])*30," points")

Column Settings:

enter image description here

Output:

enter image description here

Note:

  1. Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
  2. Use correct display name of your SharePoint columns in above formula.
  3. Wrap column names inside [] if your column name has space in it. For example: [Choice Column 5]

Official Documentations:

  1. Calculated Field Formulas

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.