I have a Formula that looks at a lot of fields to decide whether or not to mark as TRUE - it is working except for the LAST peiece:
OR(Is_EU_Mailing_Country_C__c, ISPICKVAL(Region_Created_From_C__c, "EU"), ISPICKVAL(Region_Owned_by_C__c, "EU"), MB_EU_Brand_Key_Contact__c, Manual_Include_in_EU_Sync_C__c) &&OR(Manual_Exclude_from_EU_Sync_C__c == false, Manual_Exclude_from_EU_Sync__c == false)
If either 1 of those fields is TRUE (Manual Exclude from EU SYNC C OR Manual Exclude from EU SYNC) - the formula should NOT mark as TRUE. If 1 of those 2 fields is TRUE, the formula shoud be false.
Right now it only works if both are TRUE.
Any suggestion are greatly appreciated.
Since the Manual excludes are checkboxes, You can use NOT(Checkbox__c) inside the AND to check the checkbox only if both the manual excludes are False.
AND(
OR(
Is_EU_Mailing_Country_C__c,
ISPICKVAL(Region_Created_From_C__c, "EU"),
ISPICKVAL(Region_Owned_by_C__c, "EU"),
MB_EU_Brand_Key_Contact__c,
Manual_Include_in_EU_Sync_C__c
),
NOT(Manual_Exclude_from_EU_Sync_C__c),
NOT(Manual_Exclude_from_EU_Sync__c)
)
