Formula column HYPERLINK()


So I have a formula that returns a text string based on a status, which works fine (it is a simple nested IF statement)
What I’d like is to convert that text result into a clickable hyperlink.

So what I’d really like is the implementation of the HYPERLINK() function in excel.

To be clear the text is dynamically set based on user choice, so the link column isn’t suitable.



Did this ever go anywhere? +1 for this. I’d love a URL builder style column where i can build a URL based on the data in other columns then make that a clickable link. The formula column works for this but i still need to copy + paste the link into the browser.

The above description would work for me.