Big flaw with "Is not" filter conditions' logic
Using the "Is not" condition in a filter has proven in disparate situations to be confusing at best or unusable at worst and definitely hasn't provided the output that we expected it to. Maybe it's just that expect it like this, which is why I'd like to understand if other users have the same expectation or not.
ISSUE 1 | MULTIPLE "IS NOT" CONDITIONS
Situation: I have 5 pipelines and want to see a list of deals of only pipelines 1, 3 and 5. I create a deal filter with 2 conditions: Deal > Pipeline > Is not > 2 and Deal > Pipeline > Is not > 4.
Expected behaviour: I get a list with deals only from pipelines 1, 3 and 5.
Actual behaviour: I get a list with deals from all pipelines.
Based on the feedback I got from customer support, using multiple "Is not" conditions in a filter ends up causing those conditions to annul themselves. This doesn't seem like any filtering logic that I've encountered before, especially when Pipedrive has separate filter sections for AND and OR conditions:
ISSUE 2 | USING "IS NOT" FOR FILTERING ACTIVITIES
Situation: Whenever a contact schedules a call with us using our Pipedrive scheduler link, an activity with the type "Scheduler call" is created. I wanted to get a list of contacts who never had that activity associated with them. I create a person filter with the condition Activity > Type > Is not > Scheduler call.
Expected behaviour: I get a list with only the contacts who never had that activity.
Actual behaviour: I get a list with all contacts that have ever had at least one activity that is not Scheduler call.
The reason why this one is important to us is that we use Outfunnel for email automation, and it sends emails to contacts that fall under a certain filter. We would like to stop sending emails to that contact immediately after they book a call with us, which is what happens when the Scheduler call activity is created. This one can theoretically be circumvented by creating an automation that automatically fills a new field called "Booked a call?" with "Yes" once that person has that activity and then have our filter just include in the results contacts that have that field filled with "Yes".
However, apart from the obvious hassle of setting that up, a big issue we've had in the past with Pipedrive was that we simply had too many data fields that were not really adding value from a business perspective and were contributing to a lot of data-cluttering, so we took measures to make our Pipedrive data structure a lot leaner. Adding new fields as workarounds just seems to be a step back in regards to that mentality.
Any input (from either Pipedrive or other community members) is appreciated. Once again, it could be that we just have very specific use-cases, but it would be interesting to hear your thoughts on that. It's also possible that we're simply approaching all of this wrongly