Trying to workaround the fact that can’t do both OR and AND filters by using an IF statement. This is just the beginning but I can’t get it to throw the correct result. Suspicious it is because it doesn’t work for Fields that are linked to other tables, but not sure why it wouldn’t. Am I missing something else? Perhaps because it is a string? It seems like a really easy IF statement, but it throws “No” when it should throw “reponsible”). Help!

If this can’t be fixed perhaps you have other ideas for how I can show only those entries for which a specific entity is either responsible or accountable (ideally with the ability to group by which they are)/