I have a Validation Rule (below).
TEXT(Asset_Manager_Client__r.Type__c) <> "External Asset Manager"
However when the Lookup Field Asset_Manager_Client__c has nothing in it, I don't want this Validation Rule to execute.
Both the Asset_Manager_Client__c and Validation Rule is on a custom object name Settlements__c .
3 answers
Try this:
AND(
NOT(ISBLANK(Asset_Manager_Client__c)),
TEXT(Asset_Manager_Client__r.Type__c) <> "External Asset Manager"
)
