Skip to main content

Hi Everyone,


 


I am wanting to do a validation on form submission to check to see that a person that has been entered in to a Multi person "Approvers" field is not present in the "Preparer" field.


 


This so the preparer cannot play a part in the Approval workflow.


 


I can get it to work if only one user is entered in to the "Approvers" field, and that user is the "Preparer", but as soon as I enter a second person in to the "Approvers" field, the validation no longer triggers.


 


This is what I have in the validation rule at the moment:
Preparer==Approvers


 


Thanks for you help

Hi

Try:
contains(Approvers,Preparer)
Thanks Simon

Reply