How to replace ‘@’ with “%40” in emails?
Ideally, I am looking to auto-generate a link to my external CRM (via say a concatenate formula).
I checked the help docs, but it is asking for a position etc.
Do I need to do hidden field with a Find formula to locate the @, then have another column populate the position etc.?
Is there an easier way?