Let's say I have a table with prospects from multiple companies. Is there a way to score and rank them on a company level within the same table? instead of across all companies
Yes! You can create company-level scoring within the same table using formulas and the Lookup Multiple Rows integration. [1]
Here's how:
1.
Add a Formula column to calculate company scores based on your criteria (headcount, industry, tech stack, etc.)
2.
Use Lookup Multiple Rows to count prospects per company and create relative rankings within each company
3.
Build multi-factor scoring that combines company attributes with prospect-level data - you can weight factors like growth rate, technology fit, funding, and competitive position [2]
The Formula Generator can help you create conditional logic to score prospects relative to others in their company rather than across your entire table. You can also use our built-in lead scoring feature (Add Enrichment → Score Row) which supports up to 15 custom criteria. [3]
Before diving into complex formulas, try Sculptor (top-right corner) - it can help you build this scoring system quickly and it's free to use!
If you need any more help with scoring and ranking prospects by company, I’m here to assist. Would you like to share more details about what you’re trying to achieve or any challenges you’re facing?