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
Jack DunnJack Dunn 

Why is my formula field throwing error "Error: Syntax error"?

I'm trying to create a formula checkbox to indicate if a donor qualifies for our "Giving circle" -- the criteria is that they made any recurring gifts that year OR gifted $1000 or more that year.

My field names are definitely correct, and either condition works on its own, but when I try to combine them as an OR formula it just tells me "syntax error". I've tried with and without parentheses. What am I missing here?

Formula return type = checkbox

Formula: (Recurring_Gift_Number_Last_Year__c >= 1)OR(TLCircle_Total_LastYear__c >= 1000)
 
Best Answer chosen by Jack Dunn
VinayVinay (Salesforce Developers) 
Hi Jack,

Try below formula. 
(Recurring_Gift_Number_Last_Year__c >= 1) || (TLCircle_Total_LastYear__c >= 1000)
Please mark as Best Answer if above information was helpful.

Thanks,

All Answers

VinayVinay (Salesforce Developers) 
Hi Jack,

Try below formula. 
(Recurring_Gift_Number_Last_Year__c >= 1) || (TLCircle_Total_LastYear__c >= 1000)
Please mark as Best Answer if above information was helpful.

Thanks,
This was selected as the best answer
Arun Kumar 1141Arun Kumar 1141
Hi Jack,

Try below formula.
  
OR(Recurring_Gift_Number_Last_Year__c >= 1, TLCircle_Total_LastYear__c >= 1000)


Please mark it as best answer if it helps.

Thanks