+ Start a Discussion
Glenn Nyhan 54Glenn Nyhan 54 

Formula Field Error Message - Error: Syntax error. Missing ')'

I created a formula field to look at the Event Name and if its a particular name it takes the ticket type and count of tickets is multiple by the cost of the ticket based  on the type of ticket and cost. I am get the following error message, but can't tell whats wrong with the formula
I should mention the VALUE part of the formula works fine, but in adding the IF statement I am now getting and error. Any help solving this is greatly appreciated. 

Error: Syntax error. Missing ')'


IF(Event_Specific_Name__c = 02/04/2018 CC "Meditation Training Practice Day"  + VALUE(TEXT(General_Admission_of_Tickets_Ordered__c)) * 90.00 
SandhyaSandhya (Salesforce Developers) 

From the formula you posted, there are three opening braces if you count,but only two closing braces.

Best Regards,
Glenn Nyhan 54Glenn Nyhan 54
Hi Sandhya,

IF(Event_Specific_Name__c = (02/04/2018 CC "Meditation Training Practice Day")  + VALUE(TEXT(General_Admission_of_Tickets_Ordered__c))) * 90.00

When I enter this I still get this error message - Error: Syntax error. Missing ')' And the CC (see highlighted underlined text above), which is the correct value for the Event_Specific_Name__c field. Can't figure out why this is an error, and that error is Missing ')' highlighting the CC.
Amit Chaudhary 8Amit Chaudhary 8
Can you please tell me your requirement so that we can help you in your formula
Glenn Nyhan 54Glenn Nyhan 54
Hi Amit,

I found another solution, and used the following formula which worked for my needs:

GA_Total__c * VALUE(TEXT(General_Admission_of_Tickets_Ordered__c))