Skip to content

Difference between AND vs OR logic in lists, workflows, and reports

Last updated: February 11, 2025

Available with any of the following subscriptions, except where noted:

All products and plans

There are two types of logic for multiple list filters, workflow enrollment triggers, and report filters

AND logic

To identify objects that meet all criteria within a set of list filters or workflow enrollment triggers, use AND logic. When filtering records in a list, AND logic is automatically used within a filter group.

For example, to identify contacts that are from North America AND have a lifecycle stage of Customer, click AND before adding the second filter or trigger.

When using this AND criteria, only contacts who are North American customers will be included.

Only contacts who meet the criteria in the shaded area will be included.

OR logic

To identify objects that meet at least one criteria within a set of list filters or workflow enrollment triggers, use OR logic. When filtering records in a list, OR logic is automatically used between separate filter groups.

For example, to identify contacts that are from North America OR have a lifecycle stage of Customer, click OR before adding the second filter or trigger.

When using this OR criteria, all contacts from North America, contacts who have a lifecycle stage of customer, and contacts who are North American customers will be selected. 

 

Contacts who meet the criteria in all sections will be included.

Was this article helpful?
This form is used for documentation feedback only. Learn how to get help with HubSpot.