You need to sign in to do that
Don't have an account?
Bharathwaj
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
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
You need to implement a workflow with a field update to set your picklist values based on your formula field.
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.
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?
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.