Validation - SharePoint

PaulaSousa-5991 21 Reputation points
2022-05-04T20:36:21.42+00:00

Hello!

Is it possible to use validation definitions to validate different columns?

I already have this:
=[Efficiency Assessment Deadline]>=[Implementation Date]=OR(ISBLANK([Verification Date]),[Verification Date]>=[End Date])

Now I need to add to this formula, another one.

If the field [Effective action] has the value "Yes", than the field [Support Tools] must have a value and cannot be blank.

Thank you!

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,281 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yanli Jiang - MSFT 24,121 Reputation points Microsoft Vendor
    2022-05-05T09:10:31.36+00:00

    Hi @PaulaSousa-5991
    what is the column type of Effective Action]?
    If it is the type of “Yes/No”,
    the formula is: =IF([Effective Action]=TRUE,IF(ISBLANK([Support Tools]),FALSE,TRUE),TRUE)
    If it is the type of “Choice”,
    the formula is: =IF([Effective Action]=”Yes”,IF(ISBLANK([Support Tools]),FALSE,TRUE),TRUE)
    Then, you can use "=" to concatenate these 2 formulas,Like this:
    199201-1.png

    Or, you can use AND function to concatenate multiple conditions.
    Like this:
    199120-2.png

    The result is:
    199173-3.png

    NOTE: in list validation settings you can only have one message.

    Thanks,
    Yanli Jiang

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

    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