Formula with two relationships

[Dmitry]

Is it possible to create a workflow condition based on a formula with two relationships in it?

For example, my target entity is Opportunity, and I want certain action, if the Contact, that is related to target Opportunity, is also related to other Opportunities that have saleType = "New". How can I do that?

[tanya]

do you use custom relationship one-to-many or the default many-to many?

[Dmitry]

Custom, Many-to-One (Deal-to-Contact) - "contactDeal"

[tanya]

I think no... At least I don't know the solution

https://github.com/espocrm/documentation/blob/master/docs/administration/formula.md#entitycountrelated

this function could help, but you can use it only for target record, as I can see, not for related