Field 1 is Multi picklist field and Field 2 is a text field. Trying to create a validation rule if Field 1 is not blank and Field 2 is blank, an error message should appear. Similarly when Field 2 is not blank and Field 1 is blank, an error message should come up.
Tried creating this rule which is Active but doesn't work. When I try to Edit-Save record, it shows error message even though both fields are blank.
OR(
AND(
NOT(ISNULL (Field1__c)),
ISNULL(Field2__c)
),
AND(
NOT(ISNULL(Field2__c)),
ISNULL(Field1__c)
)
)
Thanks