How to Limit Contacts per Company to 10 or Less

hi Clay, I have 3k+ contacts in the table. However, I want only a maximum of 10 contacts per company. Is there any easy way to make sure the total number of contacts per company is 10 or less?

✅1

8 comments

Clay Team
APP
·
·
Hey Gabe!!
Clay Team
APP
·
·
Here's how to surface one lead per company, or in this case, you can filter up to ten - https://www.loom.com/share/4152acbce75e4209a8db5d767050cf49?sid=e66ca291-36d6-44ed-96c3-49c160502768It's not exactly the easiest method but definitely useful to give each contact from the same company a unique label or number that you can filter by and clean it up.
Gabe D.
·
·
perfect Arturo O. thank you! For the last filter, is there a way to do equal to 10 or less?
Clay Team
APP
·
·
Yes, if the column is set to number-type which should be easy to change by editing the column, then the available filters should include that option.
:thumbsup_all:1
Clay Team
APP
·
·

36dcc817-4308-4feb-b65b-c44c06729365.png(24 kB)
Gabe D.
·
·
hi Arturo O. for this: https://app.clay.com/workspaces/128515/tables/t_CMKIePk05Tt7/views/gv_Gbv5AXT3zqTB I feel like I did the lookup wrong because when I search ATT.com, it only gives 9 and 10 to two of the contacts, but it doesn't list 10 of them properly. Any help?
Clay Team
APP
·
·
Sure! let me take a look
Clay Team
APP
·
·
Replying in DMs due to context. Closing this thread for now