function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ 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.