|October 26, 2018|
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.
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.
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!
Feel free to leave a comment about this post.