Unfortunately, this is not possible in Airtable. :frowning: I would recommend emailing firstname.lastname@example.org to ask them to please support this feature. All of my Airtable consulting clients are in desperate need of this, too.
The workaround for all of us is to use a professional automation platform like Integromat for all of automation needs.
(Note that I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link contains my personal referral code. If you have a budget for your project and you’d like to hire an expert consultant to help you with it, please feel free to contact me through my website at ScottWorld.com.)
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 should create a clickable URL in button form.