• Jack Dunn
  • NEWBIE
  • 10 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
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)