I'm trying to ensure that Accounts in an app are not duplicated. Since many companies go by different names (ex: HP, Hewlett Packard, etc.), I figured the best route would be to lump them together by their employee's email domains.
I'm having trouble thinking of the best way to do this. I can't think of a good way to do it with a formula since we don't quite have all of the "normal" excel tricks quite yet, and I'd rather not use any of my precious Zaps 🤑 to continually run this process.
In short, I just want to convert [email protected] to test.com in a separate URL text field.
Anyone had success doing something like this?