Validation - SharePoint

Question

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!

Answer 1

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.

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.