QA Graphic

Adding Hyperlink in Apple Numbers

Easy way to add Dynamic Hyperlinks to 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 Comments

Name:
Comment:

 

About

A Mac veteran since 1989, I'm here to share my experience with tips and tricks every Friday. Witnessing the evolution of Mac software and hardware firsthand, I've gained a deep understanding of how these machines work and can help you troubleshoot any issues that may come up.

Schedule

FridayMacintosh
SaturdayInternet Tools
SundayOpen Topic
Monday Media Monday
TuesdayQA
WednesdayKeyboard Maestro
ThursdayGluten Free