Question

Is it possible to add a column to list view that shows only the last comment that was made for the case (ie: the same as "Title w/ Comment", but without the Title)? The purpose for this is that I would like to include this as a separate column in exports to Excel.

Answer 1

You could expose the latest comment via a plugin, but I think there's a simpler solution. Try this:

1. Set up your FogBugz filter to include both the Title and Title w/ comments columns.
2. Export to Excel
3. Add the following formula in your first empty column in Excel:
   • =IF(D2=E2,"",REPLACE(D2,1,LEN(E2)+3,""))
   • In my formula, the data in column D is the Title w/ Comments column and column E represents the Title column.

This will remove the title from the entry and leave only the comment.