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
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.)
Apple Converts the formula to identify the columns.
Couple of Basic NotesRight-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!
Add your Comments
Feel free to leave a comment about this post.