Clickable email link to Beast Mode field
I want to make a clickable email in a table. The email field is a formula, however, and I can't get the formula to validate.
The email field I want to be clickable is "PrimaryContactEmail".
Formula for PrimaryContactEmail:
When Length(`ProcessorEmail`) = 0
I tried to create a new field "PrimaryContact Link" with the following formula:
But when I select the column name "PrimaryContactEmail", the Case formula is inserted instead. If I type the column name in, the validation check says "A column in this calculation does not exist".
How can I get the email to be clickable?