Workflow Rule to update a text field

Question

I am trying to create a workflow rule for a field update when the Lead Owner is changed from a Queue to a user only when the Queue owner = certain queues. Here is what I have so far:

AND(
ISCHANGED(Owner_Name__c), 
(PRIORVALUE(Owner_Name__c) = 'Queue - Inform') OR
(PRIORVALUE(Owner_Name__c) = 'Queue - Qualifa') OR
(PRIORVALUE(Owner_Name__c) = 'Queue - Televerde') OR
(PRIORVALUE(Owner_Name__c) = 'Queue - Market One'))

What am I doing wrong?

Answer 1

That's not how OR syntax works. You pass it a bunch of clauses and if any of them are true, it returns true (e.g. OR(condition1, condition2)). It's just like AND (notice you already use AND(condition1, condition2)). So your formula should be:

AND(
    ISCHANGED(Owner_Name__c),
    OR(
        (PRIORVALUE(Owner_Name__c) = 'Queue - Inform'),
        (PRIORVALUE(Owner_Name__c) = 'Queue - Qualifa'),
        (PRIORVALUE(Owner_Name__c) = 'Queue - Televerde'),
        (PRIORVALUE(Owner_Name__c) = 'Queue - Market One')
    )
)