AnsweredAssumed Answered

Validation on field with multiple rules

Question asked by kalsup on May 16, 2018
Latest reply on May 18, 2018 by kalsup

I am having trouble with a Validation on fields. I currently have fields that require multiple situations to apply. I cannot get the formula to work when I have more than one per field. I tried doing them as separate rules too. I might of missed something so I am asking for help. 

 

 

Field Name is Agree w/Impact Statement

 

Logic:

If Review Status is No Applicability then Agree w/Impact Statement is required

If Review Status is Currently Compliant then Agree w/ Impact Statement is required

If Action Plan Complete Date is not Blank and Review Status is Implemented then Agree w/Impact Statement is required

If Review Status is Informational and Communication sent is not blank then Agree w/Impact Statement is required

 

 

Validation:

((Review Status,"No Applicability")  && isNullOrEmpty({Self})) || ((Review Status,"Currently Compliant")  && isNullOrEmpty({Self})) || ((Review Status,"Implemented")  && (Action Plan Complete Date,not(isNullOrEmpty())) || ((Review Status,"Informational")  && (Communication Sent,not(isNullOrEmpty()))

 

Please let me know what I should be doing to get this to work cause I have like 6 more fields to apply similar logic to. 

Outcomes