Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sean O-ConnellSean O-Connell 

Help with a Workflow Formula

I am trtying to create a workflow that updates a date field when the prior value is a Queue ID (Owner ID) and is changed. 

i have been able to do it when there is a picklist value like this

ISPICKVAL(PRIORVALUE(  Queue__c ), "QC Review")&& ischanged ( Queue__c )

How do I write the below referencing a lookup owner filed rather then a picklist field

PRIORVALUE(ownerid =  "00G37000000heZl") && ischanged ( ownerid)

Thanks in advanced

Sean
 
Best Answer chosen by Sean O-Connell
Kunal01Kunal01
Hi Sean,

Try below formula 


AND(
    ISPICKVAL(PRIORVALUE(  Queue__c ), "QC Review"),
​     ISCHANGED( Queue__c ),
    LEFT(PRIORVALUE(OwnerId),3) = '00G',
    ISCHANGED(OwnerId)
)

~KR
 

All Answers

Kunal01Kunal01
Hi Sean,

Try below formula 


AND(
    ISPICKVAL(PRIORVALUE(  Queue__c ), "QC Review"),
​     ISCHANGED( Queue__c ),
    LEFT(PRIORVALUE(OwnerId),3) = '00G',
    ISCHANGED(OwnerId)
)

~KR
 
This was selected as the best answer
Dale LotteDale Lotte
This one doesn't work either:

AND(
    ISPICKVAL(PRIORVALUE(  Queue__c ), "QC Review"),
​     ISCHANGED( Queue__c ),
    LEFT(PRIORVALUE(OwnerId),3) = '00G',
    ISCHANGED(OwnerId)
)
Tried to change the initial OwnerID and then replaced the picklist field properties to the topessaywriter (http://topessaywriter.org) info.