October 26, 2018

Adding Hyperlink in Apple Numbers

When opening up a CSV file from Jira, you may want to add a link to the tickets. The easiest way to do this is to create another column and then add the following Hyperlink function.

Easy way add a link using Apple Numbers

=HTPERLINK("https://company.atlassian.net/browser/"&B1,B1)

What the formula does is take the value in Column B and then appends it to the standard URL for your company Jira account. The final linked text is also the value in Column B. (Simply change the URL to point to the correct location.)

Numbers Hyperlin
Apple Converts the formula to identify the columns.

Couple of Basic Notes

Right-click the column that contains the values that you want to have links to and select the 'Add Column After'

Simple do the first item, then use the cell fill down functionality (Yellow dot in the bottom cell, and drag down)

Once completed, Hide column B so you don't see duplicate ticket ids.

I wasn't able to find a way to apply the HYPERLINK formula so that it uses an existing cell data. If you know of a way, let me know!

Comments

Add your Comments

Feel free to leave a comment about this post.

- Feel Free to add HTML to your comment!