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
Dennis Borders 3Dennis Borders 3 

Syntax Error Help

Hi, am getting "Syntax error. Missing ')' on this validation rule but can't see what I'm doing wrong - any help greatly appreciated, thanks!

 AND(  
    ISPICKVAL (Case_Category__c, "Other" ),  
    ISBLANK("Other" Category )
    )
Best Answer chosen by Dennis Borders 3
Akhil AnilAkhil Anil
Hi Dennis,

Your formula would be something like this
  
AND(  
    ISPICKVAL (Case_Category__c, "Other" ),  
    ISBLANK(Other_Category__c)
    )

Use the insert field option to use the right API name of the field in the ISBLANK function. 

Kindly mark it as an answer if that resolves your issue.

All Answers

Akhil AnilAkhil Anil
Hi Dennis,

Your formula would be something like this
  
AND(  
    ISPICKVAL (Case_Category__c, "Other" ),  
    ISBLANK(Other_Category__c)
    )

Use the insert field option to use the right API name of the field in the ISBLANK function. 

Kindly mark it as an answer if that resolves your issue.
This was selected as the best answer
Dennis Borders 3Dennis Borders 3
Perfect, it worked!  Thank you!!!