You need to sign in to do that
Don't have an account?
Freida Lindsey
Formula help needed
I am trying to build an advanced formula field that will calculate a total from some pick list fields I have on my lead page in a sandbox, I have 4 controlling pick list fields with 6 possible choices in each and each of them has a dependent pick list field with a scale of 5 - 0 points that defaults based on the choice in the controlling field associated with it. The associated dependent pick list field is the one I need to use to add together to get the total. Any help would be appreciated.
NameType
Capability Match with Needs (Controlling)
Capability Match Likert scale (Dependent)
Timeline/Pricing Likert scale (Dependent)
Timeline/Pricing Expectations (Controlling)
Clarity of request Likert scale (Dependent)
Clarity of Request (Controlling)
Funding Info Likert Scale (Dependent)
Funding Information (Controlling)
NameType
Capability Match with Needs (Controlling)
Capability Match Likert scale (Dependent)
Timeline/Pricing Likert scale (Dependent)
Timeline/Pricing Expectations (Controlling)
Clarity of request Likert scale (Dependent)
Clarity of Request (Controlling)
Funding Info Likert Scale (Dependent)
Funding Information (Controlling)
All Answers
1. Create formula field and choose data type as Number.
2. Try below formula,
Kindly mark this answer as best answer if it solves your problem.
Note: Kindly use API name of picklist fields and their values.
Regards,
Sagar
VALUE(TEXT(Capability Match Likert scale)) + VALUE(TEXT(Timeline/Pricing Likert scale)) + VALUE(TEXT(Clarity of request Likert scale)) + VALUE(TEXT(Funding Info Likert Scale))
If this solves your issue, please mark it as best answer or solved