I am trying to build a validation rule that prevents a multi-select picklist field (CR Value Add) from being edited on Non-Ultimate Account page layouts.
This requires the ISCHANGED parameter. How do I successfully use ISCHANGED with a multi-select picklist?
The validation rule works for the other fields that are regular picklists (CR Account Type/Classification), but I cannot get CR Value Add to work. It says only certain functions work with multi-select picklist fields.
Here it is:
AND(
Ultimate_Parent_Account__c != null
, OR(
AND(ISCHANGED(CR_Account_Type__c)
, TEXT(CR_Account_Type__c)
!= TEXT( Ultimate_Parent_Account__r.CR_Account_Type__c)
)
,
AND(ISCHANGED(Key_Account_Classification__c)
, TEXT(Key_Account_Classification__c)
!= TEXT( Ultimate_Parent_Account__r.Key_Account_Classification__c)
)
,
AND(ISCHANGED(CR_Value_Add__c)
, TEXT(CR_Value_Add__c)
!= TEXT( Ultimate_Parent_Account__r.CR_Value_Add__c)
)
)
