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
Admin89Admin89 

Requesting help on formula - Error: Syntax error. Missing ')'

Maybe I've just been staring at this for too long, but I can't find what it is I'm missing. Would anyone be willing to take a look with fresh eyes and make suggestions?

When I click "Check Syntax" it highlights the word "One" in one of the text field values and shows the Error: Syntax error. Missing ')'

I want the checkbox field to be marked as true when any of the conditions are met. each segment before the or sign "||", is one condition.

Got any ideas, please share. Thanks!

( (TEXT(Years_Since_Bankruptcy_Discharged__c) = "Yes" && TEXT( Re_established_credit_after_bankruptcy__c ) = "Yes") || (TEXT(Bankruptcy__c) = "No") || (TEXT(Years_Since_Bankruptcy_Discharged__c) = "One to two years since bankruptcy discharged" && TEXT( Re_established_credit_after_bankruptcy__c) = "I have not made more than one late payment in the past year”) ||(TEXT(Years_Since_Bankruptcy_Discharged__c) = "One to two years since bankruptcy discharged" && TEXT( Re_established_credit_after_bankruptcy__c) = "I have not made more than two late payments in the past two years")|| (TEXT(Years_Since_Bankruptcy_Discharged__c) = "More than two years since bankruptcy discharged" && TEXT( Re_established_credit_after_bankruptcy__c) = "I have not made more than one late payment in the past year”) || (TEXT(Years_Since_Bankruptcy_Discharged__c) = "More than two years since bankruptcy discharged" && TEXT( Re_established_credit_after_bankruptcy__c) = "I have not made more than two late payments in the past two years”) )
 
Best Answer chosen by Admin89
Alain CabonAlain Cabon
 "I have not made more than one late payment in the past year”  (last character is not correct)
 "I have not made more than one late payment in the past year"

All Answers

Alain CabonAlain Cabon
 "I have not made more than one late payment in the past year”  (last character is not correct)
 "I have not made more than one late payment in the past year"
This was selected as the best answer
AnkaiahAnkaiah (Salesforce Developers) 
Hi Admin,

Can you please explain your requirement?

Thanks!!
AnkaiahAnkaiah (Salesforce Developers) 
try with below formula.
  
OR((TEXT(Years_Since_Bankruptcy_Discharged__c) = "Yes" && 
TEXT( Re_established_credit_after_bankruptcy__c ) = "Yes"),
(TEXT(Bankruptcy__c) = "No"),
(TEXT(Years_Since_Bankruptcy_Discharged__c) = "One to two years since bankruptcy discharged" && 
TEXT( Re_established_credit_after_bankruptcy__c) = "I have not made more than one late payment in the past year”),
(TEXT(Years_Since_Bankruptcy_Discharged__c) = "One to two years since bankruptcy discharged" && 
TEXT( Re_established_credit_after_bankruptcy__c) = "I have not made more than two late payments in the past two years"),
(TEXT(Years_Since_Bankruptcy_Discharged__c) = "More than two years since bankruptcy discharged" && 
TEXT( Re_established_credit_after_bankruptcy__c) = "I have not made more than one late payment in the past year”), 
(TEXT(Years_Since_Bankruptcy_Discharged__c) = "More than two years since bankruptcy discharged" && 
TEXT( Re_established_credit_after_bankruptcy__c) = "I have not made more than two late payments in the past two years”) )

If this helps, Please mark it as best answer!!

Thanks!!
Admin89Admin89
@Alain Cabon, that worked. Thank you!