I'm receiving an error for a validation rule. Any help would be great! Essentially I'm trying to create a validation on the opportunity record to say that If the stage= Closed Won or Sent Membership Agreement and the Profile = System Admin then we should require a Yes/No value for a field
Make three fields required if stage = Closed Won or Sent Membership Agreement
Only accept a Yes/No Value from one field
Only work for people with a System Admin profile
Formula
AND(
ISPICKVAL( StageName ,'Closed Won'),
ISPICKVAL(StageName, "Sent Membership Agreement"),
,ISBLANK(Existing_Aetna_Optum_Cigna_Clients__c),
ISBLANK(Accepts_Insurance_before_ABC__c),
ISBLANK(Looking_For_Practice_Growth__c),
AND(
$Profile.Name <> "System Administrator",
AND Accepts_Insurance_before_ABC__c <> Yes,No
)
<> Yes,No
is invalid, missing final paren for the initial AND, last AND is invalid syntax.