function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Phillip Moseley 2Phillip Moseley 2 

I have a validation rule that is based off several fields and one profile. I need to add another profile to rule and I'm not getting any Syntax errors, but when I got to test, it does not work. Any suggestions on the formula to get this to work?

Here is what I have today which works:
AND(
$Profile.Name = "Sales Partner Group",
(Primary_Partner_Involved__c  <> ""),
ISBLANK(TEXT(Partner_Type__c)  
))

I need something similar to this below that will work where I add an additional profile:

AND(
$Profile.Name = "Sales Partner Group",
$Profile.Name = "Sales Group",
(Primary_Partner_Involved__c  <> ""),
ISBLANK(TEXT(Partner_Type__c)  
))
Best Answer chosen by Phillip Moseley 2
CharuDuttCharuDutt
Hii Phillip Moseley
Try Below Validation Rule 
AND(
OR($Profile.Name = "Sales Partner Group",
$Profile.Name = "Sales Group") ,
(Primary_Partner_Involved__c  <> ""),
ISBLANK(TEXT(Partner_Type__c)  
))
Please Mark It As Best Answer If It Helps
Thank You!
 

All Answers

CharuDuttCharuDutt
Hii Phillip Moseley
Try Below Validation Rule 
AND(
OR($Profile.Name = "Sales Partner Group",
$Profile.Name = "Sales Group") ,
(Primary_Partner_Involved__c  <> ""),
ISBLANK(TEXT(Partner_Type__c)  
))
Please Mark It As Best Answer If It Helps
Thank You!
 
This was selected as the best answer
Phillip Moseley 2Phillip Moseley 2
Thanks for the help! This worked great.