+ Start a Discussion
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12 

Based on Picklist i need to update Text field

Hi all,

Based on picklist values i need to update Text field. is it possible.

Thanks in adv
ShashForceShashForce
It is possible. Are you trying it using workflow rule or Apex?
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
Hi Shashank,

So can you please help me on workflow for this. I need this data
Picklist,   Text
PD (NA), 207.7
PD (UK), 174.95
CN (NA), 149
CN (UK), 157.4
CN (Ind), 24.4
CN (China), 24.4
CN (Japan), 120

Can you please send me screen shots also.

Thanks in adv.
ShashForceShashForce
Hi,

Please user this formula in your workflow field update:

CASE(TEXT(picklist_field__c), "PD (NA)", "207.7", "PD (UK)", "174.95", "CN (NA)", "149", "CN (UK)", "157.4", "CN (Ind)", "24.4", "CN (China)", "24.4", "CN (Japan)", "120","")

You should replace picklist_field__c with the name of your picklist field.

If this answers your question, please mark this as the Best Answer for this post, so that others can benefit from this post.

Thanks,
Shashank
azu.shaik1.3965080575576013E12azu.shaik1.3965080575576013E12
If have less values in picklist like above you can use the formula field 

IF(Picklist =='PD (NA)',207.7,IF(Picklist =='PD (UK),',174.95,F(Picklist =='CN (NA)',149,))).................

try the above 
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
HI Shashank,

What i will give the rule criteria, Can u send me the screen shots Please.

Thanks in adv.
ShashForceShashForce
If you want it to run everytime a record is created and edited, you can setup the criteria as just "true", so it will always fire. Something like this:

User-added image
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
Hi Shshank,

I am getting below error. can you please help me.

User-added image
ShashForceShashForce
Please add an extra "" at the end. In the CASE() function, there should be a default value given at the end.

Something like: "Partner 4", "", "Partner 5", "", "")
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
The below error i am getting. while i give like this("PD (NA)", "207.7") also i am getting same error.

User-added image
ShashForceShashForce
In your case, since the field type is number, use null for 0 instead of "".

Something like: "FTC Admin (Ind)", 24.4,null)

Or something like: "FTC Admin (Ind)", 24.4,0)

If this answers your question, please mark this as the Best Answer for this post, so that others can benefit from this post.

Thanks,
Shashank
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
I will give for zero or numbers(0,1,2,3....) like this.
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
Please help me urgent.

Thanks in adv.
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
Please help me urgent.

Thanks in adv.