Sharepoint List Column Validation

Terrell Chong 1 Reputation point
2022-03-20T15:16:18.003+00:00

I have 4 column which look like the screenshot below
184798-image.png

as you can see, the 1st and 2nd row is choice, and 3rd and 4th is comment, grey area means that column should not be able to filled in

all data coming in will be null at 1st, the blank is just another choice created by me to enable employees to choose that one in case they misclick.

so if intervention required, then the no intervention required one row will not be able to fill in, same as the column for comments, the same thing applies vice versa.

please let me know fi more information required.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,793 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
516 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Echo Du_MSFT 17,116 Reputation points
    2022-03-21T05:41:40.843+00:00

    Hello @Terrell Chong ,

    Welcome to Q&A Forum!

    Please follow the steps:

    1.Create two Choice columns named [Reason for delay(require intervention)] and [Reason for delay(No require intervention)]. And they only have a "Yes" option.

    184989-1.jpg

    2.Use the below List Validation Formula:

    =AND(OR(AND([Reason for delay(require intervention)] = "Yes",ISBLANK([Reason for delay(No require intervention)])),AND([Reason for delay(No require intervention)] = "Yes",ISBLANK([Reason for delay(require intervention)]))),OR(AND(ISBLANK([Comments(intervention required)]),NOT(ISBLANK([Comments(intervention not required)]))),AND(NOT(ISBLANK([Comments(intervention required)])),ISBLANK([Comments(intervention not required)]))))  
    

    185083-2.jpg

    3.Here is my test:

    185010-test5.gif

    Thanks,
    Echo Du

    =======================================

    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.