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/are the formula(s) ?

=HYPERLINK()

Put this formula:

=HYPERLINK("https://www.itilreporting.com/"&A2)

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("https://www.itilreporting.com/"&A2,"click here")

Interesting Topics