1

I have a picklist field which has value Yes and No. I would like to know if I can update this picklist field value based on a formula field.

The formula field calculates whether the value will be yes or no.

6
  • Instead of creating a separate formula field, can't you use the same formula in a workflow (field update) to update the picklist field value?
    – Avinash
    Jan 20, 2016 at 0:03
  • I can , but I would have to create a new workflow rule. I have limited workflow rules left for my org, so trying to find a work around.
    – SfdcBat
    Jan 20, 2016 at 0:29
  • What about putting the logic in Apex?
    – Avinash
    Jan 20, 2016 at 0:32
  • From what you are saying I guess picklist can not be updated using a formula field. I was wondering to make the picklist as text type and update the value based on a formula. Doing this I would have changed the picklist to text field type.
    – SfdcBat
    Jan 20, 2016 at 0:35
  • As far as I know, updating a field of any type can be done through Apex, Workflow field update and Visual workflow/Process Builder. Without these, you have to make it a formula field.
    – Avinash
    Jan 20, 2016 at 0:39

1 Answer 1

4

Using Workflow Field Update to set a picklist value requires a unique workflow for each possible picklist value to set.

However, you can use ProcessBuilder to set picklist fields via a formula. This was delivered in Summer 15. Here is an example where Field some picklist has two possible values - Choice00 and Choice01. Using the value of some_currency_fld__c, the picklist is set dynamically

enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .