Need to create a project schedule? Try our Gantt Chart Template!

New Discussion-Style Comments in Google Spreadsheets Perfect for Collaboration

comments feature in google spreadsheets

When I need to collaborate with somebody on a spreadsheet, such as a project schedule, calendar, or to-do-list, I often use Google Docs. So, when I saw Google’s announcement about discussion-style comments, I got really excited.

If you normally use Microsoft Excel, you’re probably familiar with what Excel has always referred to as a “cell comment.” You can right-click on a cell and select Insert Comment and then add whatever notes you want. This is also how Google Docs worked originally, but now Google has defined those kinds of comments as “Notes” and redefined a cell “Comment” to be more like a discussion thread for a specific cell. The image below compares a comment in Excel 2010 to the new Google spreadsheet comment.

Examples of Comments in Excel and Google Docs

This change by Google really makes a lot of sense, especially given the emphasis that Google Docs places on collaboration. The comments now behave just like the comment threads you see in blogs, forums, and social media.

Each cell can have it’s own separate comment thread. You can mark a comment as “resolved” to make the discussion thread no longer pop up when hovering over the cell. But, the comments are not deleted when marked as resolved – all the comments for the spreadsheet are still available by clicking on the Comments button at the top of the document. The following image from the Google Docs help article Overview of comments and discussion shows what the discussion thread looks like when you click on the Comments button.

Discussion Threads via Comments Button

Discussion threads viewed using the Comments button (image from Google Docs support article)

Still a Use for Regular Notes

Comments are for communicating with the other people who are using your document. There are still plenty of reasons for using notes instead of comments.

If you want to include a description for a column heading or use a note to provide more information about a particular cell, you can insert a note by going to Insert > Note. The image below shows an example of a note on a column heading:

Example of a Note added to a cell in a Google spreadsheet

Example of a Note added to a cell in a Google spreadsheet

In case you are concerned about compatibility issues with Excel, if you upload an Excel document to Google Docs, the “comments” in Excel are converted to notes (just what you’d expect).

Use Case: Project Tracking

Project Tracking Template

I recently published a new Project Tracking template designed as a communication tool for a service provider and client to plan and discuss tasks related to some project. This template serves as a perfect example of where the new discussion-style comments might be used.

The example below shows a comment added to a cell that explains why a task was changed to “On Hold” …

Notifications within a Project Tracking spreadsheet

Comment used as a notification of status change within the Vertex42 Project Tracking Template.

The above image also shows that when a comment is added to a cell, a little notification flag shows up next to the worksheet name with the number of comments in that worksheet. When you hover your mouse over the notification flag, all the comments become visible.

I’ve added the project tracking template to the Google Docs template gallery. You can find a link to the Google Docs version on the Project Tracking page.

0 comments… add one

Leave a Comment