I was struggling with a similar issue, and found a useful workaround:
Create a Button field instead of a Formula field and insert your formula in the “URL formula” section. Insert the button field into your email automation however you like, and it s...