Hello Testing minds,
Recently i have prepared a template in excel for the Defect tracking and the fields i added are mentioned below, will you please guide me or suggest me which fields are necessary and which are not? and advise for new fields too.
TEST CASE ID:
EXPECTED RESOLUTION DATE:
Now the really important thing is how many of these items are "required" and the MOST important thing...
Why reinvent the wheel?
There are hundreds of capable free systems out there that capture the information you're looking for. Excel breaks down after about 50-100 issues (Sorting, searching, closed items).
Please consider using an already developed system that meets your needs because although you're trying to do just the critical stuff (and I applaud you for that) within a month or two you will find that your solution is limited.
(This is from multiple rounds of experience. Sometimes you have to let the company learn the hard way, but if you can have a more permanent solution in your back pocket when the first attempt fails, you'll look like a genius.)
I have to endorse what wholly is saying. When I first started at the company I am in now templates and tracking reports were set-up in excel. The first project we did the project lead had to have an admin to do the excel work as it took so much time and effort. I admit the project was on an application that created a lot of defects but it was a headache.
Rather than purchase or use a tool that was available (We could not purchase as we could not get the money). We did end up creating a tool in MSAccess that with some improvements lasted for several years and included other Test Scenario and Test case management and tracking as well as defects.
Today I would try and use one of the tools available but i would certainly look at using MSAccess before using Excel.
To have the defect tool ready for use in a project took less than 3 days.
Indeed I can't imagine defect tracking without keeping history of defect status (and addressee) changes with comments on each step as well as attachments. Also I hope your management will not start asking more soon: support for root-cause-analysis, effort estimation and tracking per defect, different reports, etc.