Hello,

I am trying to create a scoring system for my clients so I can rate each client.  I have created several drop down lists for my salesforce team to choose from.  (Each picklist has a choice between 1 2 3).  What I want to do is at the end of the test use a formula to provide the final score the client received.  I tried to use the ISPICKVAL however I was unsuccessful.  If I had a picklist of numeric values 1 2 3 4 5, how would I create a formula to read those values and add other values of other picklists that have 1 2 3 4 5 and provide a final sum?

Thanks