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.

  • 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 '16 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 '16 at 0:29
  • What about putting the logic in Apex? – Avinash Jan 20 '16 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 '16 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 '16 at 0:39
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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.