How to Extract Link from a Column?

4

*The following solution no longer works at the moment. Updates to link display options where made, but they also breaks the functioning of this solution.

To get the hyperlink separate from the “Log in with Atlassian Account” title, you can use this in a new column:

Link.Embed().ToText()

link-to-embed-text
link-to-embed-text.png1850×566 101 KB

You’ll see in the screenshot that I have full links and the link with the title, and this extracts the actual link text from both.

Then you can create a hyperlink with the ticket number as the title:

If([Link Text].IsNotBlank(),thisRow.[Link Text].Hyperlink(Right(thisRow.[Link Text],[Link Text].Length() - 39)),"")

link-to-text-to-titled-link
link-to-text-to-titled-link.png2132×568 103 KB

I used an “If” statement so there isn’t an error if there is ever a row where there is no link, but if every row has a link, you can remove the “If”.

You can probably boil this down even more to get a full formula in only one extra column, but breaking it up in two helped me visualize each step a little better.