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.
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.
- Thank you Don,
This sounds like an approach that we should look into. We are also looking into a Flow to update the score column, but the PnP sounds encouraging as well.
Thanks again to all who took a shot at this one!
