You need to sign in to do that
Don't have an account?
Ellsa James
How can I assign a numeric value to a text value in a picklist?
I have a picklist with 4 text values. I want to assign a numeric value to each text value. I then want to multiply the chosen value by a number field. Can anyone help me with the syntax?
Picklist field = Plan_object__c
Picklist Values = Low,High,Medium,None
Number Field = R_Complex__c
Picklist field = Plan_object__c
Picklist Values = Low,High,Medium,None
Number Field = R_Complex__c
Why don't you simply use a formula field for R_Complex__c?
For example, to assign 1 when picked value is "Low", 2 when "High" and so on, you can have a formula like this one: Hope this helps,
Fred
All Answers
Why don't you simply use a formula field for R_Complex__c?
For example, to assign 1 when picked value is "Low", 2 when "High" and so on, you can have a formula like this one: Hope this helps,
Fred
As you have a answer to your question, you should mark it as solved.
Fred