Clay Icon

Creating a Counter in Clay to Count and Filter Employees by Company

ยท
ยท

Is there a simple way to create a counter in clay? My example is I want to count and filter by the number of people at a company in a table

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You can count the number of people at a company in a Clay table using the Lookup Multiple Rows integration. Here's how:1. Use the Lookup Multiple Rows feature to scan a column containing company identifiers (like domain, name, or LinkedIn URL) 2. The integration will count how many cells match your specified company value 3. You can perform this lookup within the same table or across different tablesOnce you have the count, you can use conditional formulas to filter or perform specific actions based on the company headcount. For example, you can set conditions to process only companies that match certain headcount criteria.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Adrian B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: