Skip to main content
Topics#Data ManagementBLD Admin's Question
BLD Admin asked in #Data Management
Nov 8, 2017, 10:32 PM

Create a formula field (text) by a picklist field value

I have a picklist field. It's values are percentage buckets. Based on a certain percentage bucket, I need to have another field (field 2) automatically populate with a certain text string. Based on field 2, I need to have another field (field 3) populate with a certain text string.

 

I am running professional edition (I know there are some limitations), but I was hoping for help here. I've tried everything I can think of without success.

 

Here's a visual of what I need (although a little messy)

 

Create a formula field (text) by a picklist field value

 

Any help would be appreciated!
5 answers
  1. Ahilesh Ragavan Radhakrishnan (Simplus)
    Nov 8, 2017, 10:42 PM
    You can set up the 3 picklist fields with "Field Dependencies" feature.

     

    You have to set up 2 dependencies like this:

     

    1) Field 1 - Controlling Field, Field 2 - Dependent Field

     

     

    2) Field 2 - Controlling Field, Field 3 - Dependent Field

     

    Take a look here on how to set it up:

     

    Define Dependent Picklists

     

    https://help.salesforce.com/articleView?id=fields_defining_field_dependencies.htm&type=0 (https://developer.salesforce.com/docs/atlas.en-us.fundamentals.meta/fundamentals/adg_simple_app_adv_field_dependencies_try_it_out.htm)

     

    Create a Dependent Picklist

     

    https://developer.salesforce.com/docs/atlas.en-us.fundamentals.meta/fundamentals/adg_simple_app_adv_field_dependencies_try_it_out.htm

     

     
Write an answer...
0/9000