Validation - SharePoint

PaulaSousa-5991 21 Reputation points


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!

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

    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:

    Or, you can use AND function to concatenate multiple conditions.
    Like this:

    The result is:

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

    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