Syntax error. Missing ')' - Answers - Salesforce Trailblazer Community
Ask Search:
Chelsea AngellChelsea Angell 

Syntax error. Missing ')'

Hello Community,

I'm a bit in over my head and am not terribly familair with writing validation rules. I'd like to write a rule that requires completion of 'Capabilites_Required__C' at Stage 1-Identified Opp, type New Logo, and for it only to apply to our Sales EMEA profile. I've written the below rule, which may have more than one issue, but currenlty I'm getting a syntax error specifying "')'". Any help would be creatly appreciated! Many thanks in advance.

AND( 
OR (
ISPICKVAL(StageName,"Stage 1-Identified Opp"),
AND( ISPICKVAL(Type,"New Logo"),
ISBLANK( Capabilities_Required__c )
)
$Profile.ID = "00e22000000QGxN"
)
Best Answer chosen by Chelsea Angell
Deepak AnandDeepak Anand
Try this = 
AND(
    $Profile.Name = "<Please Use Profile Name>",
    ISPICKVAL(StageName, "Stage 1-Identified Opp"),
    ISPICKVAL(Type, "New Logo"),
    ISBLANK(Capabilities_Required__c)
)

All Answers

Deepak AnandDeepak Anand
Try this = 
AND(
    $Profile.Name = "<Please Use Profile Name>",
    ISPICKVAL(StageName, "Stage 1-Identified Opp"),
    ISPICKVAL(Type, "New Logo"),
    ISBLANK(Capabilities_Required__c)
)
This was selected as the best answer
Chelsea AngellChelsea Angell
Terrific, thank you so much, Deepak! I'm no longer getting the syntax error. I'll give it a test now. Much appreciated.