Team, I have been struggling to fire a trigger when a Lead is assigned to a queue. As you can see, I do not want to trigger all new leads, but only those with certain criteria. I have tried Owner email blank and owner email equal queue email. Neither one is working. What am I missing?
#Workflow Rules #Triggers #Queues #Sales Cloud AND( ISCHANGED( LD_Last_Routed__c ), ISPICKVAL( Status , "MQL" ), Owner_Email__c = "fakeemail@example.com.invalid" , OR( ISPICKVAL( MQL_Touch_Type__c , "Contact Us Form" ), ISPICKVAL( MQL_Touch_Type__c , "Inbound Email/Call" )) )
The formula you are using is supposed to run when the LD_Last_Routed__c field is updated because you have put ISCHANGED on this field. So If you want to run this when a new record is created. You can replace ISCHANGED function with ISNEW or maybe you can remove both functions.
AND(
ISNEW(),
ISPICKVAL( Status , "MQL" ),
Owner_Email__c = "fakeemail@example.com.invalid",
OR( ISPICKVAL( MQL_Touch_Type__c , "Contact Us Form" ), ISPICKVAL( MQL_Touch_Type__c , "Inbound Email/Call" ))
)
