-
Change picklist according to Formula field.
Hi all,
I need to change picklist value automatically without any editing on the record whenever my formula field changes. My formula field shows ‘Active’ & ‘Inactive’ Status , so i need whenever my formula changes to Active picklist will change to Active and vice versa.Thanks
-
1 Reply
-
Hi Sourabh,
This requirement can be achieved by two ways:
- Field update using workflow. But you have to create unique workflow for each possible picklist value.
- Using process builder.You can have entry criteria as per your requirement. The formula for update record will be : IF(FormulaFieldName,’Active’,’Inactive’).
Thanks
Log In to reply.
