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
jpx79jpx79 

Formula field taking the sum of picklist fields

Hi,
 
I have ten picklist fields and based on whatever is chosen here, I want the formula field to represent the sum of these ten fields.
 
Relationship score = 1,2,3,4 based on the option they chose
Geographic Alignment score = 1,2,3,4 based on the option they chose
Outsourcing savvy =1,2,3,4 based on the option they chose
 
Bid score = Relationship score + Geographic Alignment score + Outsourcing Savvy score
 
There are aseven other fields.can someone give me the syntax for these three above fields?
 
Thanks
John
 
JakesterJakester
I think you're going to need an intermediate step in here: create number formulas that turn the picklist values into the scores you want. Once you've done that, you can create rollup summary fields that sum those number values.

The number formula fields will look something like:
Code:
case(relationship__c,
"option 1",1
"option 2",2
etc.
)

 
Marc GauthierMarc Gauthier

 

FORUMLA for Bid Score Forumla field with Number data type.

VALUE(text(Relationship_Score__c))+
VALUE(text(Geographic_Alignment_Score__c))+
VALUE(text(Outsourcing_sawy__c))