Aug 21, 2020 12:23 PM
Hey! I think I see where you might be running into trouble on this one: The view filters only really take into account Contact information, and not the associated Deal info.
However, I do have a workaround that I myself use in situations like this: You can still Filter by List Membership, and Lists are more expansive than Filters in what you can include.
In this case, I'd put together an Active List of contacts with the following Filters: Deal Name Contains any of "#". This will pull contacts who are associated with Deals that have # in the name into the List, covering both the (a) and (b) requirements you're looking for.
Then, once you've saved that List, you can go into your View and Filter by List Membership (name of List), pulling in only the Contacts who have an associated Deal where they're a contact, and the deal name contains a "#"!
Best of luck!