I have a situation where I work with companies who over the years all of their contacts have left, resulting in some cases leaving me with NO contacts. In other words, I have situations where I used to have many contacts for each company, and now over time, I have none.
For each contact, I have a field that identifies (no/yes = 0/1) on whether each person is a contact in the company. I have a simple spreadsheet layout that lists each contact, their company, and whether they are still there. I am now realizing that when I am filtering by just the 'yes' for those that are contacts, I am omitting entire companies that have all 'no's. I need a simple way to identify those companies that do not have any contacts so I can know who I need to reach out to and find a new contact. I need something simple, because I am dealing with 1000s of contacts, and I cannot individually go through them, and for legal reason, cannot miss any company.
I was thinking that a simple condition field situation might work, for example, making all the fields for all the contacts red if they belong to a company who have all contacts that say no. But, I am not sure how to script it. Or, if this even the correct approach. I am running FM 12 PRO.