+ Start a Discussion
BharathwajBharathwaj 

How to use a formula field's value to update a picklist

Hi,

 

I need to update a picklist field based on the result of a formula field.

My exact requirement is like this: I use a custom object for Bug Tracking based on the Estimated Time taken for resolution I categorize them as L1,L2,L3.

Now I want to use this formula result to update my picklist field. If I don't manually enter the Category value too the formula field will give the correct category which should be updated in the category picklist.

 

please help.

Bharath 

Best Answer chosen by Admin (Salesforce Developers) 
BharathwajBharathwaj

Enth,

 

Thanks for the insight. I used 3 Field Updates to Update the picklist when the Formula field returns L1,L2, L3.

Its working fine now.

 

thanks,

Bharath.

All Answers

EnthEnth

You need to implement a workflow with a field update to set your picklist values based on your formula field.

BharathwajBharathwaj

Enth,

 

Thanks for the insight. I used 3 Field Updates to Update the picklist when the Formula field returns L1,L2, L3.

Its working fine now.

 

thanks,

Bharath.

This was selected as the best answer
ChristineCGChristineCG

Is there a way to do this when there are 50 values in the picklist that need to be set by a Case statement instead of using 50 workflow rules?

BharathwajBharathwaj

Hi,

It will be easier to do the same with a Trigger for BeforeUpdate or BeforeInsert according to your requirement.

Code: if(case_picklist__c != null){

      case_picklist__c=case_custom_picklist__c;

}

Hope it was useful.

Thanks,

Bharath.