When filtering records using a multiple checkbox property, HubSpot currently offers filters such as ‘is any of’ or ‘is none of’, but there is no way to find records where a specific option is the only value selected.
For example, if a multiple checkbox property has 3 possible options and I filter by ‘is any of x’, the results will include:
- Contacts with only X selected
- Contacts with X but also Y selected
- Contacts with X and also Y and Z selected
There are times where I need to identify contacts who have X selected and no other options. At present, this required adding separate exclusion criteria for every other possible value. This is cumbersome, particularly for properties with many options or options that change over time.
It would be useful to add an ‘is only’ filter operator for multiple checkbox properties. Selecting ‘is only X’ would return records where X is the sole selected value, excluding any records that also contact Y or Z or any other option.
This would make segmentation more precise and simplify the creation of views, segments and reports!