Adding an issues log
On the Openbox Ribbon in Excel there is a section for creating and adding to an issues log, as shown below.
This is intended to be a simple and flexible log for keeping track of live issues, when they have been cleared and who cleared them.
To add a log to any Excel model, click “Create log”. A new sheet called Issues will be added – this is taken from the Excel template so you can customise it with your own colours and fonts as you wish.
You can then add a new issue to the log by selecting the cell in the model that has the issue and clicking “Add issue”. A new row will be added to the log, with a link to the cell, a date, and you will be prompted for a description.
The “Show log” button simply jumps to the “Issues” sheet at any time.