Would be two suggestions, one is ability to add tags/categories to comments.
Second would be ability to configure the tag(s) to be shown in the latest comments column that was recently added
We use multiple columns to add notes and comments for a mission from particular program areas such as volunteers, logistics, safety etc. When entering in row comments, they could tag or auto tag with their areas (Logistics, Volunteer, Safety, etc.)
Multiple columns within the sheet would display latest comments from the selected tag(s) so that notes could be shown in the sheet for different areas. This would let us save all notes in one location, but still display them in separate columns for review and discussion.