I am in the CRM. What I am trying to do is go though all my contacts to see how much accounts each contact is connected to. I cannot believe there is no simple way for Monday CRM to easily show this information. For example we work with different accounting firms have a specific contact at this firm. This individual contact is connected to 10+ of our clients. I need a column on monday to show this count on how many of our accounts are connected to each contact. I tried the AI column and I tried the Formula column and tried pivot table (monday freezes because of too much data), nothing works. I cant believe a CRM would not easily have this information to identify center of influence.
Monday has this information because when I link the connected column it shows all the accounts and a bubble of a count, but cant get a count of it in a separate column to sort the data.
Does some one know how I can get this data natively on Monday. I do not want a 3rd party solution for this.