sharepoint online list calculated column from multiple choices

Question

sharepoint online list calculated column from multiple choices

Bailly, Alain 46

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

Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2022-05-12T01:46:08.17+00:00

@Bailly, Alain

Thank you for your question.

We are currently looking into this issue and will give you an update as soon as possible.

Thank you for your understanding and support.
Bailly, Alain 46 Reputation points

2022-05-12T05:39:47+00:00

Hello Emily,
I think i founded why we can't see these columns: i allow multiple selections.
I just tested with another column (COL1) with a dropdown list, i can select the column (COL1) to create a calculated column, but once i enable the multiple selections in (COL1) i cannot see the column (COL1) to create calculated column.
I hope it is clear
In any cases, if you have a solution i will be very interesting
Thanks a lot
Alain

Accepted answer

0 additional answers

Your answer

Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2022-05-12T01:46:08.17+00:00

@Bailly, Alain

Thank you for your question.

We are currently looking into this issue and will give you an update as soon as possible.

Thank you for your understanding and support.
Bailly, Alain 46 Reputation points

2022-05-12T05:39:47+00:00

Hello Emily,
I think i founded why we can't see these columns: i allow multiple selections.
I just tested with another column (COL1) with a dropdown list, i can select the column (COL1) to create a calculated column, but once i enable the multiple selections in (COL1) i cannot see the column (COL1) to create calculated column.
I hope it is clear
In any cases, if you have a solution i will be very interesting
Thanks a lot
Alain

Answer 1

Emily Du-MSFT 51,836 Microsoft External Staff

@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.

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.

Jyothi Sakre 1 Reputation point

2023-05-26T16:47:32.3733333+00:00

How about if Monday column field has multiple values like ABS;Home; in case of power automate?

Requirement : wanted to update value to new field "ABS Field" if Monday(multiple choice field) has only "ABS" value. Please help!

Share via

sharepoint online list calculated column from multiple choices

0 additional answers

Your answer