You need to sign in to do that
Don't have an account?
kumar.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
Based on picklist values i need to update Text field. is it possible.
Thanks in adv
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.
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
IF(Picklist =='PD (NA)',207.7,IF(Picklist =='PD (UK),',174.95,F(Picklist =='CN (NA)',149,))).................
try the above
What i will give the rule criteria, Can u send me the screen shots Please.
Thanks in adv.
I am getting below error. can you please help me.
Something like: "Partner 4", "", "Partner 5", "", "")
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
Thanks in adv.
Thanks in adv.