Forum Discussion
Seeking help with a formula for a Calculated Column
As @ganeshsanap stated, the calculated column does not have a way to evaluate a multi-choice column. However, you can accomplish this using custom list formatting. The Score will not be stored in SharePoint, but will be visible in the views as it is calculated live.
SharePoint List Formatting King, Chris Kent(@thechriskent), has a blog post to walk you through how to do it. List formatting can be a little daunting, but if you are working with calculated columns, the leap is not too bad. Chris has tons of examples to accomplish all kinds of list formatting magic and is the moderator of the PnP List Formatting Samples repository.
Here is the blog post mentioned above: https://thechriskent.com/2019/02/07/formatting-multi-select-values-in-list-formatting/
Here is a link to the PnP List Formatting Samples site: https://pnp.github.io/List-Formatting/
Good luck! Don
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.
Pandra This is not possible using SharePoint out of the box capabilities as calculated columns does not support multiple selection choice columns in formulae.
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.