CTS's Christmas Tip of the Week - Comments in sheets

"Alone we can do so little; together we can do so much."

 – Helen Keller

This quote is a simple reminder of the power of collaboration. Something which is more important than ever right now. If you and your colleagues work together on Google Sheets often, you may have found it difficult to keep track of comments. Lucky for you, Google has just made some great enhancements allowing users to review, respond to and resolve comments easier than ever before.
Let’s take a look...

Firstly, you can now review comments and conversation threads in a sidebar. 

UseCommentsSidebarToSeeConversationsInSpreadsheet

This allows for quicker replies and resolutions. It’s also an easy way to create new conversations with your colleagues. You can navigate to this sidebar in a number
of ways: 

  • By clicking the Comment Icon in the Appbar (next to the present icon)
  • By hovering over the Sheet tab and clicking ‘See all comments’
  • By clicking on the cell with the comment applied and clicking ‘Open
    all comments’

Secondly, you can now apply filters to find the most relevant comments for getting your work done when a document is highly collaborative. For example, you might want to filter to show all comments that are ‘for you’ and require your response.

ApplyFiltersInSidebarToFindRelevantFeedback

 

Again this cuts through the noise and allows you to get through your tasks quicker. When tasks are complete or conversations have been resolved, you can take action directly from the sidebar.

TakeActionDirectlyWhenTasksAreComplete

 

Last but not least, you can now use the new navigator tool to page through comment threads in the comment overlay. This allows you to very quickly scan through comments on each tab within your spreadsheet without the need to open the sidebar. However, you may find it easier to do this depending on what you are trying to achieve.

open all comments from cell

 

So there we have it - a super simple way of discovering and navigating through comments in Sheets. There are no admin changes required and this feature will be ON for everyone. This feature is available to all Google Workspace customers, as well as G Suite Basic and Business customers.

Recent posts

Safer Gambling with CTS on Google Cloud

On Tuesday 6th September, I attended a brilliant customer forum on Safer Gambling, hosted...

Becoming a Certified Cloud Digital Leader with Google

The Google Cloud Digital Leader certification is considered the first step into the...

Retail Pop-up - Frontline Worker Technologies

👉 Do you want to empower your frontline staff to make local business decisions?👉  Want...

Recent posts

Safer Gambling with CTS on Google Cloud

On Tuesday 6th September, I attended a brilliant customer forum on Safer Gambling, hosted...

Becoming a Certified Cloud Digital Leader with Google

The Google Cloud Digital Leader certification is considered the first step into the...

Retail Pop-up - Frontline Worker Technologies

👉 Do you want to empower your frontline staff to make local business decisions?👉  Want...