Sharepoint list validation

Angela 1 Reputation point
2022-03-09T15:35:49.97+00:00

I am trying to create a validation for a column in a sharepoint list. All columns are multiple choice.
The validation should result in: multiple choice options can only be selected in one of the columns.
If a multiple choice option is selected in column 1, it is not available in column 2/3/4.

Is there a way to achieve this?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,852 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CaseyYang-MSFT 10,321 Reputation points
    2022-03-10T09:16:11.08+00:00

    Hi @Angela ,

    You could use the following formula to limite multiple choice options can only be selected in one of the columns.
    List settings > validation settings

    =IF(OR([choice]=[choice1],[choice]=[choice2],[choice]=[choice3],[choice1]=[choice2],[choice1]=[choice3],[choice2]=[choice3]),FALSE,TRUE)  
    

    Note: [choice], [choice1], [choice2], [choice3] are multiple choice column name. Remember to replace them.

    My test result:

    181891-1.jpg


    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.

    1 person found this answer helpful.