How to assign one picklist value to another picklist list

[Arjunmca]

Hi,

I need to assign a value of picklist to another picklist. But those two picklists are same, picklist name is Status with values 'Open', 'Close'.

These two picklists are in different places, if one picklist value modifies, automatically another picklist value should update.

Note: Both fields must be picklists.

I tried field update with workflow rules  using the below formula, but it doesnot work.

IF(Picklist1_Value__c <> Picklist2_Value__C, Picklist2_value__c, false)

IF(Picklist2_Value__c <> Picklist1_Value__C, Picklist1_value__c, false)

Thanks,

Arjun

[JeffM]

If the picklists are on the same object, you could run into a WF order of execution problem.  Since you can't control which WF runs first, when you change Picklist_1, if the WF that checks it runs first, it will just reset the value back to Picklist_2.  You could try adding the ISCHANGED(Picklist_1) and ISCHANGED(Picklist_2) to each of the WF so either will only apply to the edit if the correct field changed.

[Arjunmca]

 Ok, as you said i can put a rule in WF with ISCHANGED(Picklist1__c). If Picklist1 changes the value, then i need to assign that value to antoher picklist. But how do i know which value selected Picklist1__c and how can i assign that value to Picklist2.

Using 'Immediate Workflow Action ->  Field Update Type '  i can't update same value of Picklist1 to Picklist2.

Because i dont know which value selected in Picklist1.

How to resolve this problem.