I have done the setup listed here (https://help.salesforce.com/articleView?id=000004000&type=1) for round robin lead assignment, but 'd like to do a lead assignment based on two criteria: the lead's status (Appointment Set) and it's sub source- a custom field (Facebook).
My formula looks like this :
AND( TEXT(Status) = "Appt. Set", TEXT(Lead_Sub_Source__c) = "Facebook"), MOD(VALUE(Lead_Number__c) ,2) + 1, 0 )
I'm planning on rotating leads with this specific status and sub source between just two owners.
I keep getting an error that I have an extra ',' or '(' and I've tried modifying the formula with &&, AND etc., but just can't make it work.