Hi guys, I have a list of prospects with a URL domain for each .I want to filter on companies with less than 5 prospects in the table. I tried formulas but didn't succeed. Any advice ?
To filter companies with less than 5 prospects in your table using URL domains, you can use the Lookup Multiple Rows integration. Here's how:
1. Use the Lookup Multiple Rows integration to count prospects for each company.
2. Scan the domain column to count matching values.
3. Create a new column with the count results.
4. Use a conditional formula to filter companies with less than 5 prospects.
For example, you could use a formula like: IF(COUNT_OF_PROSPECTS < 5, "Include", "Exclude").
If you need more detailed guidance on setting this up, please request human assistance by clicking on "Talk to a person".