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
Arif Iqbal 5Arif Iqbal 5 

Error- Syntax error. Missing ')'


Hi Team,

I have a formula and seems bizzare as it is working in other places but not for mailing address. I get the following Error: 

Error: Syntax error. Missing ')'

Formula:
IF( 
Disable_Sharing_Main_Contact_Address__c = TRUE, NULL, 
( 
"Mailing Street: " (MailingAddress)
) 
)
karthikeyan perumalkarthikeyan perumal
Hello, 

I think you are trying to  concodinate  the string with value of mailing address.  ("Mailing Street: " (MailingAddress))


use some thing like below

IF( 
Disable_Sharing_Main_Contact_Address__c = TRUE, NULL, 
( 
"Mailing Street: "+Text(MailingAddress)
) 
)

Hope this will help you, 

Mark Best ANSWER if its works for you. 

Thanks
karthik