[SalesForce] How to use formula to transform text to integer

I want to use a dropdown list for attributing values to a field. However, for the end user, I want to show easy labes instead of numbers.

I wonder how I can set up a formula to transform that text to integers.

The labels would be: easy, medium and hard. They should be mapped to 0.5, 1 and 1.5.

I need to transform those to compute them in another formula.

Here is what it would look like in a basic Python function:

def mapping(x):
    y = 1
    if x == 'easy':
         y = 0.5
    elif x == 'medium':
         y = 1
    else:
         y = 1.5

How can I solve this using formulas in Salesforce?

Best Answer

if you wanted the user to choose from text values in the picklist, you could do a conversion to numeric factor in the formula itself, using the CASE function.

Suppose you have the three picklist values 'Easy', 'Medium', 'Hard' then you could rewrite your formula field as

amount__c * CASE(Boost_Factor__c, 'Easy', 0.5, 'Medium', 1, 'Hard', 1.5, 1)   //final argument is the default if no match

Related Solutions

[SalesForce] Formula: convert text to date

The DATEVALUE function is used to convert Date/Time values into just a Date value. If you want to convert a Text value into a Date value, try using DATE(text). See Using Date and Date/Time Values in Formulas for more help with Date and Date/Time formulas.

[SalesForce] Picklist and Text IF Formula

Your formula will never return true. One picklist field can never simultaneously have two options selected.

You haven't given the error text, which makes the specific problem harder to identify, but I think the following might more closely represent what you are looking for:

IF(
    AND(
        // all inner clauses must be true for the whole to be true
        OR(
            // either inner clause must be true for the whole to be true
            ISPICKVAL(PicklistField1__c, "Option 1"),
            ISPICKVAL(PicklistField1__c, "Option 2")
        ),
        OR(
            // either inner clause must be true for the whole to be true
            ISPICKVAL(PicklistField2__c, "Option A"),
            ISPICKVAL(PicklistField2__c, "Option B")
        ),
        CONTAINS("X:Y:Z", Owner__c)
    ),
    "International", // value if all the above is true
    "Domestic" // value if all the above is false
)

As I learned from @sfdcfox, you can shave some compile size with some fancy restructuring:

IF(3 =
    CASE(PicklistField1__c, "Option 1", 1, "Option 2", 1, 0) +
    CASE(PicklistField2__c, "Option A", 1, "Option B", 1, 0) +
    IF(CONTAINS("X:Y:Z", Owner__c), 1, 0), "International", "Domestic"
)

Best Answer

Related Solutions

[SalesForce] Formula: convert text to date

[SalesForce] Picklist and Text IF Formula

Related Topic