You need to sign in to do that
Don't have an account?
Phillip Moseley 2
Validation rule is showing error for profile anytime opportunity is edited instead of just on the fields within the fomula
I have the following validation rule that is working when Primary Partner field has a value it is showing error to update Partner Detail field, however the error is also being given anytime the Opportunity is edited. I need the formula below to only show error when the Primary Technology Partner field has a value and the Partner Type field is blank. Does anyone have any suggestions on how to make this error show just based off the two fields in formula and not when the opportunity is edited. Thanks.
AND(
OR(
INCLUDES(Primary_Technology_Partner_Involved__c, "Achilles"),
INCLUDES(Primary_Technology_Partner_Involved__c, "Adopt - Pendo"),
INCLUDES(Primary_Technology_Partner_Involved__c, "Bureau Van Dijk"),
INCLUDES(Primary_Technology_Partner_Involved__c, "Commerce Decisions"),
ISBLANK(TEXT(Partner_Type__c))),
OR(
$Profile.Name = 'Jaggaer Sales Partner Group',
$Profile.Name = 'Jaggaer Sales',
$Profile.Name = 'Sales Salesforce Super User' ))
Thanks,
Maharajan.C
All Answers
Can you please try the below formula:
Thanks,
Maharajan.C
Thanks,
Maharajan.C
Thanks,
Maharajan.C
Thanks,
Maharajan.C
As per your description, need throw an error when Primary_Technology_Partner_Involved__c field have any value & Partner_Type__c field have empty..
If my understanding is corrent then use the below formula.
If this helps, Please mark it as best answer.
Regards,
Ankaiah Bandi