Using Lookup Multiple Rows for Advanced Data Counting
You can't do this with a regular formula since formulas can't look across rows. Use the Lookup Multiple Rows integration instead:
- 1.
Add a new column and select Lookup Multiple Rows
- 2.
Set it to look up your company domain column within the same table
- 3.
Configure it to count matches
- 4.
Then add a Formula column that checks if the count > 1 and marks "Yes" [1]
Try Sculptor (top-right corner) - describe what you want and it'll build this workflow automatically. [2
