locked
Validation rule RRS feed

  • Question

  • Hello,

    I have the following validation rule:

    =IF(AND(ISBLANK([Complaint Channel])=TRUE,Source="Complaint "),FALSE,IF(AND(ISBLANK([Complaint Type])=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK(Number)=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK([Claimant's Name])=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK([Complaint Number])=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK([Entry Date])=TRUE,Source="Complaint"),FALSE,TRUE))))))

    This rule validates some fields used when we register the value "Complaint" in [Source] field.

    I need to add another validation to this rule. When the [Response date] is registered, it should be mandatory to fill in the [Response Number] and [Decision] fields. Can this be added?

    Thank you!

    Wednesday, March 27, 2019 3:57 PM

Answers

  • Hi,PMS16,

    I have tested the new validation rule below and it works properly with the requirements of two parts. Please have a try.

    =IF(AND(ISBLANK([Complaint Channel])=TRUE,Source="Complaint "),FALSE,IF(AND(ISBLANK([Complaint Type])=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK(Number)=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK([Claimant's Name])=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK([Complaint Number])=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK([Entry Date])=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK([Response Number])=TRUE,ISBLANK([Response date])=FALSE),FALSE,IF(AND(ISBLANK(Decision)=TRUE,ISBLANK([Response date])=FALSE),FALSE,TRUE))))))))

    Best Regards

    Jerry Xu


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    • Marked as answer by PMS16 Thursday, March 28, 2019 10:37 AM
    Thursday, March 28, 2019 8:37 AM

All replies

  • Hi,PMS16,

    I have tested the new validation rule below and it works properly with the requirements of two parts. Please have a try.

    =IF(AND(ISBLANK([Complaint Channel])=TRUE,Source="Complaint "),FALSE,IF(AND(ISBLANK([Complaint Type])=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK(Number)=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK([Claimant's Name])=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK([Complaint Number])=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK([Entry Date])=TRUE,Source="Complaint"),FALSE,IF(AND(ISBLANK([Response Number])=TRUE,ISBLANK([Response date])=FALSE),FALSE,IF(AND(ISBLANK(Decision)=TRUE,ISBLANK([Response date])=FALSE),FALSE,TRUE))))))))

    Best Regards

    Jerry Xu


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    • Marked as answer by PMS16 Thursday, March 28, 2019 10:37 AM
    Thursday, March 28, 2019 8:37 AM
  • Thank you very much for your help!

    It's working :)

    Thursday, March 28, 2019 10:37 AM