We are using a Monday Board as a CRM and have customers who belong on teams, but also customers are “solo”. I am trying to create a view using Filters to only show people on a team. I would like for this view to be dynamic, because we are adding and subtracting customers all the time, and filtering by a list of teams would require changes every time someone left or joined.
I am moving over from a Google Sheet and previously I was using a =countif nested in an =if to determine if a value in a specific column had any other rows with the same value - from there I could use that column to filter.
After reviewing the Formulas available in Monday, I can’t seem to find any that support using inputs from multiple items, mostly just referencing a single value in the same item.
An ideas how I can achieve this desired view?