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
PhilippBPhilippB 

Validation Rule - Error: Syntax error. Missing ')'

When trying to create a validation rule for a Status I am receiving the above error message. 

I wrote Error Condition Formula as follows: 

AND(
TEXT( CG Status ) = "Banned",
ISBLANK(TEXT(Banned_Reason_CG))
)

CharuDuttCharuDutt
Hii Phillip
Try Below Validation 
AND(
ISPICKVAL(CG_Status__c,'Banned'),
ISBLANK(Banned_Reason_CG)
)
Please Mark It As Best Answer If It Helps
Thank You!
PhilippBPhilippB
thanks for the help sadly then it gives me this error: Error: Field Banned_Reason_CG__c is a picklist field. Picklist fields are only supported in certain functions.
CharuDuttCharuDutt
Hii philipp
Try Below Validation I've Made Changes 
AND(
ISPICKVAL(CG_Status__c,'Banned'),
ISBLANK(TEXT(Banned_Reason_CG))
)
Please Mark It As Best Answer If It Helps
Thank You!
 
PhilippBPhilippB
Thanks. Ended up not working with the ISPICKVAL, but only with the TEXT
CharuDuttCharuDutt
Please Close Your Query By Marking It As Best Answer So It Also Helps Others In Future
Marathi MulgaMarathi Mulga
Thanks - Marathimulga (https://marathimulga.com)