sharepoint online list calculated column from multiple choices

Bailly, Alain 46 Reputation points
2022-05-11T06:05:26.013+00:00

Hello everybody
I have 5 choice columns, MONDAY, TUESDAY, WEDNESDAY, THURSDAY and FRIDAY
In each column I have a choice list, ABS, HOME, SITE, TRAVELLING …
My goal is to create a calculated column (verifyweek) to check:
If MONDAY = ABS and TUESDAY = ABS …. Then “HOLIDAYS”
My problem is when I want to create this calculated column, I cannot select the columns MONDAY TUESDAY ….
I have read that it is not possible to get information from a column with multiple choices.
Do you confirm?
Is somebody have another solution?
Many thanks to all
Alain

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,802 questions
{count} vote

Accepted answer
  1. Emily Du-MSFT 44,071 Reputation points Microsoft Vendor
    2022-05-12T08:29:45.28+00:00

    @Bailly, Alain

    Yes, by default, calculated column does not support choice field with checkboxes (allow multiple selections).

    As a workaround, you could create a flow as following pictures show.

    201336-1.png
    201383-2.png
    201384-3.png


    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.


0 additional answers

Sort by: Most helpful