Referencing the last comment to update a column
I've started a Software Issue tracker and so far I've found ways to display the information how I'd like it. I hit a road block when trying to display the latest comment a field on the spreadsheet.
I'd still like to use the comments thread so other Project Stakeholders can reference the communication for each issue but I'd like to reference the last comment in that thread and display it in a column on the spreadsheet. This will help other users get a one page view of all open issues and the latest comment without having to open the comments dialogue box.
Can anyone help me accomplish this?