Skip to main content
Topics#FormulasMargaret Carr's Question
Margaret Carr asked in #Formulas
Oct 16, 2024, 1:32 PM

Error: Syntax error. Extra ','

I have checked commas and parenthesis but continue to get the syntax error of a missing comma or parenthesis. I'm looking for some help to clean up this formula.

 

This is what I have started:

IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 10000), IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pHjR&oid=00D61000000HOeU&lastMod=1729020447000","Producer Circle"), 

IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 5000), IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pHeb&oid=00D61000000HOeU&lastMod=1729020377000","Celebrity Circle"), 

IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 2500), IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pBvm&oid=00D61000000HOeU&lastMod=1729020291000","Director Circle"),

IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 1000), IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pHOT&oid=00D61000000HOeU&lastMod=1729020215000","Musical Director Circle"),

IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 500), IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pHBa&oid=00D61000000HOeU&lastMod=1729020135000","Designer Circle"), 

IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 250), IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pGnN&oid=00D61000000HOeU&lastMod=1729019901000","Choreographer Circle"), 

IF (Account.PatronDonate__AmountDonatedInLastNDays__c >= 100), IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pGVd&oid=00D61000000HOeU&lastMod=1729019771000","Ensemble Circle"), ""))

 

#Formulas  #Roll-up Summary Fields

3 answers
  1. Srinivasa Reddy Somu (Cohesity)
    Oct 16, 2024, 1:41 PM

    Hi @Margaret Carr,

    Try this -

    IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 10000, 
       IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pHjR&oid=00D61000000HOeU&lastMod=1729020447000", "Producer Circle"), 
       IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 5000, 
          IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pHeb&oid=00D61000000HOeU&lastMod=1729020377000", "Celebrity Circle"), 
          IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 2500, 
             IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pBvm&oid=00D61000000HOeU&lastMod=1729020291000", "Director Circle"), 
             IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 1000, 
                IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pHOT&oid=00D61000000HOeU&lastMod=1729020215000", "Musical Director Circle"), 
                IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 500, 
                   IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pHBa&oid=00D61000000HOeU&lastMod=1729020135000", "Designer Circle"), 
                   IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 250, 
                      IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pGnN&oid=00D61000000HOeU&lastMod=1729019901000", "Choreographer Circle"), 
                      IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 100, 
                         IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pGVd&oid=00D61000000HOeU&lastMod=1729019771000", "Ensemble Circle"), 
                         "")
                   )
                )
             )
          )
       )
    )
Write an answer...
0/9000