Bug Tracker

Configure the Settings sheet

Select the ‘Settings’ sheet and enter the following information:

  • People: List the names of all the people involved in your project.
  • Status: You may rename one or more of the default statuses.
  • Priority: You may rename one or more of the default priorities.

🟢 Tip: To remove an entry in the ‘People’ list, right click on the entry and select ‘Delete -> Table Rows’.

Start logging bugs

The ‘Tasks’ sheet allows you to manage all your bugs. Each bug contains the following 9 columns:

  • ID: Enter the ID of your choice for each bug. For example, you may start with 0001.
  • Bug: Enter a bug description. If the amount of information you need to enter does not fit into this cell, consider adding a 'note' by right-clicking in the cell and selecting 'New Note'. If you need to include images, text formatting and large amounts of imformation, we suggest logging the bug in a Word document and then hyperlinking the Bug cell to the Word document. These documents can be stored on Microsoft OneDrive or Google Drive.
  • Status: Select a status from the dropdown menu.
  • Priority: Select a priority from the dropdown menu. (P1 = Most urgent, P4 = Least urgent)
  • Created Date: Enter bug creation date.
  • Due Date: Enter the date which the bug should be fixed by.
  • Created By: Select the person who logged the bug. Choose your name if you're logging the bug.
  • Assigned To: Assign the bug to someone in the team. They will be responsible for fixing the bug.
  • Progress: Enter a number between 0 and 100. This will be formatted as a percentage and will be color coded automatically.

🟢 Tip: All dates must be entered in the following format: January 1, 2023

🟢 Tip: When the ‘Due Date’ has passed the current date, it will appear in red.