AnsweredAssumed Answered

Validation on field with multiple rules

Question asked by kalsup on May 16, 2018
Latest reply on May 31, 2018 by N M

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



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




((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.