Skip to main content
Topics#Data ManagementKristi Folden's Question
Kristi Folden (Olis, Inc.) asked in #Data Management
May 6, 2010, 4:26 PM

Advanced "IF" formula syntax error: Missing )

I am attempting to generate a custom lead & contact scoring system.  I created a new object which includes seven custom scoring fields (5 picklists and 2 check boxes).  I would like to assign a point value system for each picklist/check box and create a subtotal field for each scoring criteria.  I am attempting to use an advanced formula field to assign a number (ie, score) for each picklist value and report that number in the subtotal field.  After I do this for each of the seven scoring criteria fields, I will add them all up into a Total Score field.  I am having trouble with the process of assigning a numeric value for each picklist option.  After reading other related posts, I got my formula to this point but am still getting a syntax error:

 

Advanced

 

My picklist values include parentheses.  Is this creating a problem?

 

Any help is greatly appreciated!!

 

Kristi
14 answers
  1. Mark Passovoy (WatchGuard)
    May 6, 2010, 5:12 PM
    Try this:

     

     IF(

     

     ISPICKVAL( Journal_Quality__c , "Lesser-Known Journals (Reviews of multiple word titles"), 1,

     

     IF(

     

     ISPICKVAL( Journal_Quality__c , "Average Journals (BBA, Analytical Chemistry"), 2,

     

     IF(

     

     ISPICKVAL( Journal_Quality__c , "Respected Journals (JBC, JACS, FASEB"), 3,

     

     IF(

     

     ISPICKVAL( Journal_Quality__c , "Elite Journals (Science, Nature, PNAS"), 4,null

     

    )

     

    )

     

    )

     

    )
Write an answer...
0/9000