Troubleshooting Lead Count Issues in Lookup Method
Bo (. Hello! I've been using this method https://www.loom.com/share/a39a4569d95244b7886026f3c70812c7?sid=c6b9a548-41ca-4a3a-9b95-c411d3b3ec6a to count the number of leads from one company. It was working fine but now it's acting up. There's no change in the table whatsoever or in the data. Two things are going wrong for me on this:
- 1.
Lookup isn't always correct, when I rerun the cells then its corrected
- 2.
When the lookup is fine in some instances the formula doesn't give the correct answer. For example: where three records will be found it'll assign a unique ID occurrence of 3 to all of them, or will miss one of the records entirely.
Please help, thanks!