Creating a Numbering Formula for Leads in Clay
Hey everyone! 👋 I’m trying to create a numbering formula in Clay to get the first lead from each company. In Excel, I would normally use a formula like =IF(A2=A1, B1+1, 1), but I’m having trouble replicating that logic in Clay's Formula Generator. I've tried using this formula: Compares the current row's company domain Company Domain with the previous row's company domain Company Domain If they match, it increments the number from the previous row. If not, it starts counting from 1. But it’s not giving me the correct output. I need a way to number leads per company, so I can easily filter out just the first one from each group. Any ideas or suggestions on how to get this to work properly? Appreciate any help! 🙏