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

As someone who has worked on Macs since 1989, I will use my experience to share tips and tricks with you on Fridays. As a Mac user since 1989, I have seen the evolution of Mac software and hardware, and I know how Mac computers work. I also know how to troubleshoot and fix Mac problems that can arise.

Schedule

SundayOpen Topic
Monday Media Monday
TuesdayQA
WednesdaySnagIt for QA
ThursdayPython
FridayMacintosh
SaturdayInternet Tools