SharePoint list- using a calculated column to return a value in a multichoice field

Question

Hi Team

I want to use a calculated column to return a value on 2 multi-choice fields. I'm aware there's a workaround by following these steps I want to use a calculated column to return a value on multi-choice field. I'm aware there's a workaround by following these steps https://sharepoint.stackexchange.com/questions/132852/how-to-calculating-column-from-multi-choice-column

However I don't want to have to delete the column and re-add it as we already have data in there.

Is there another work-around here where I don't need to follow the above steps and I don't have access to power-apps

The formula I used for the 2 columns are =If(AND([Collateral Updates] = "SOPs", "BAT", "WI", [What collateral updates are required for BAT] = "SOPs", "BAT", "WI"), "Non BAT Collateral Updates", "BAT Collateral Updates")

Regards,
Harry

Answer 1

Hi @Harry N Nomikos ,

By default, calculated column does not support choice field with checkboxes (allow multiple selections). So it is not possible to achieve your needs through formulas.

Supported Columns in SharePoint Calculated Column Formula：

• Title.
• Created.
• Modified.
• A single line of text.
• Choice (menu to choose from) | Single Selection.
• Number (1, 1.0, 100).
• Currency ($, ¥, €).
• Date and Time.
• Yes/No (checkbox).
• Calculated (calculation based on other columns).
• Task Outcome.
• External Data.
• Content-Type Columns.

If you don't want to follow the steps in the link you provided and don't have access to Power Apps. As a workaround, you could create a flow as following pictures show.

Reference: https://learn.microsoft.com/en-us/answers/questions/844658/sharepoint-online-list-calculated-column-from-mult

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.