Add an hyperlink to a ticket number with a formula in an excel report

I usually put a link in my report to open in a quick and easy way a ticket, it can be an incident, a problem, a change request, etc. so instead to open the ticketing tool, from my excel, I just have to click on the number and it will do automatically. It is very useful when I have to open for instance 10 tickets. Of course, the ticketing tool should allow it, I mean open a ticket from an external source.

formula excel


When I use the formula ?

To create a link to open an incident ticket from excel.


How to use the formula ?

The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".


How is the formula ?


Put this formula:


I can put the ticket number instead of the cell reference so I just have to replace A2 by for instance 5. In case if I want to put a name or a comment to the link, use this one:

=HYPERLINK(""&A2,"click here")

Interesting Management