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
jgreene.ax1178jgreene.ax1178 

Validation rule error

Hi all, 

 

I have this rule to stop a convert if the Title field isn't filled out. 

 

AND($RecordType.Name = "Professional", ISBLANKVALUE(Title__c) = TRUE
TEXT(Relationship_with_School__c) <> "Prospective Family"

 

And yet I get this error:

 

Error: Syntax error. Missing ')'

 

Any help would be appreciated!

 

Thank you.

Best Answer chosen by Admin (Salesforce Developers) 
Noam.dganiNoam.dgani

think you will get an error on the second one as well for leaving out a comma.

 

try this:

 

AND($RecordType.Name = "Professional", ISBLANKVALUE(Title__c),
TEXT(Relationship_with_School__c) <> "Prospective Family")

 

hope this helps.

if it does, please mark it as resolved.

All Answers

Navatar_DbSupNavatar_DbSup

Hi,

 

You have missed ‘(’ at the end.

 

Try the below formula as reference:

 

AND($RecordType.Name = "Professional", ISBLANKVALUE(Title__c) = TRUE TEXT(Relationship_with_School__c) <> "Prospective Family")

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 
Noam.dganiNoam.dgani

think you will get an error on the second one as well for leaving out a comma.

 

try this:

 

AND($RecordType.Name = "Professional", ISBLANKVALUE(Title__c),
TEXT(Relationship_with_School__c) <> "Prospective Family")

 

hope this helps.

if it does, please mark it as resolved.

This was selected as the best answer
jgreene.ax1178jgreene.ax1178

Thanks a bunch!  I appreciate the quick feedback.

 

-JG