Ranking Employee Engagement Within a Company: How to Guide

Adam · 2025-12-11T15:05:05.659Z

Hi Guys, i am trying to compare people within a company. I want to create a ranking column that shows each person’s engagement rank within their company (1 = highest, 2 = second highest, etc.). Got all the engagement just need to rank them within the company. Any one has any idea how to do this?

Ranking Employee Engagement Within a Company: How to Guide | Clay

Clay Support
APP
·
·
You can create a ranking column using a Formula column. Here's how:
1.
Add a new column and set the type to Formula [1]
2.
Use the Formula Generator to create a ranking formula that compares engagement scores within each company [2]
3.
Your formula should rank people by engagement score, grouped by company (1 = highest engagement, 2 = second highest, etc.)
For complex ranking formulas like this, I'd recommend trying Sculptor (our built-in AI tool in the top-right corner) - it can help you build the exact ranking formula you need for free. Let me know if Sculptor helps or if you need more specific guidance!
Clay Support
APP
·
·
Is that what you were looking for?
Adam
·
·
Sculptor isn’t helping me alot
Clay Support
APP
·
·
Since Sculptor isn't working well for your ranking formula, let me help you with the manual approach.
Add a Formula column and try this prompt in the AI Formula Generator: "Rank people by engagement score within each company, where 1 = highest engagement score in that company, 2 = second highest, etc."
Use / to reference your engagement and company columns when typing the prompt. [1] The Formula Generator should create the ranking logic you need to compare engagement scores grouped by company. [2]
Let me know if that works better for you!
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
I understand Sculptor hasn't been very helpful, and I apologize for the inconvenience. Would you like to provide more details about the ranking issue you're facing so I can assist you further?
Adam
·
·
i have a list with around 3000 people. Every one of them has shown a number of engagement. Based on that number i only want the highest within the company. Sculptor is saying it is not possible to rank across multiple rows
Clay Support
APP
·
·
You're right that ranking across multiple rows is tricky. For finding the highest engagement person per company, try using a Formula column with this approach:
Create a formula that finds the maximum engagement score for each company, then compares each person's score to that maximum. Something like "if this person's engagement equals the max engagement for their company, return 1, else return a higher number." [1]
The Formula Generator should help build this logic - use / to reference your engagement and company columns when prompting it. This will effectively give you the top performer per company without needing cross-row ranking.
Clay Support
APP
·
·
Was this helpful?
Clay Support
APP
·
·
If you still need help with creating the ranking column or have more questions about comparing engagement within companies, I’m here to assist. Would you like to share more details about what you’re trying to achieve or any specific challenges you’re encountering?
Adam
·
·
doesnt work
Clay Support
APP
·
·
Sorry to hear that it’s still not working for you. I’ll connect you to one of our human agents who can assist further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
image.png(93 kB)
Adam
·
·
https://app.clay.com/workspaces/211453/workbooks/wb_0t73xzzoZahi5CZDXgU/tables/t_0t73yufPMeP2pMNKxSf/views/gv_0t73yugdETG4WpgqwFP
Natalie H.
·
·
Hi Adam, thanks for reaching out! Sculptor is correct, unfortunately at the moment it's not possible to rank across multiple rows. As a workaround, I would suggest using either formulas or a "Use AI" column to rank the engagement (ex: return low engagement if less than 5 records found in the "Engagement" column), and from there you can add a filter for which company you would like to analyze the engagement for.
Feel free to share more details about your ranking method as well, happy to brainstorm more!

19 comments