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.
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 ?
=HYPERLINK()
Put this formula:
=HYPERLINK("https://www.itmanagementetools.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.itmanagementetools.com/"&A2,"click here")
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...