I am trying to create a validation rule that says if Type of event (picklist field) is Account Management or the Subject (Picklist field) is Account Management then picklist field Account Management Type can't be left blank and you can only fill out field Account Management Type if the type and subject state Account Management.
Do I do something like the below?
AND(
ISBLANK(TEXT( Account_Management_Type__c),
OR
TEXT(Subject) <> "Account Management",
TEXT(Type) <> "Account Management")
)
Thank you in advance for your assistance. :)
7 respuestas
Personally I would split this into 2 Validation Rules
AND(
OR(
TEXT(Type) = "Account Management",
TEXT(Subject) = "Account Management"
),
ISBLANK(Account_Management_Type__c)
)
AND(
TEXT(Type) <> "Account Management",
NOT(ISBLANK(Account_Management_Type__c))
)
