I can’t answer if or when link columns might be supported in monday formulas. However, three other methods that you might consider:
General Caster - available in the monday app marketplace.
Integromat - third party integration tool.
See below.
I have not used the General Caster app. But, I believe it would work for you. Integromat would definitely work. If you want more info on that let me know.
Finally, the third alternative would to simply use a Text column instead of a Link column. The main advantage that the link column has is that in addition to the URL you can specify the display text. Both will create a clickable link when displayed on the board.