Arrow left
Back to product guides
Google Sheets Tips

Comment History in Google Sheets: Explained

In this article, you will learn what you can do with the Comment History in Google Sheets. 

What is the Comment History?

The Comment History allows you to view the communication records with your collaborators via the comment function of Google Sheets on a sheet or in an entire file. Thus, it is beneficial when you want to refer to your previous or ongoing communication with others in a Google Sheets file.

How to open the comment history

  1. Go to the top right corner of a worksheet.
  2. Click a speech balloon icon there.
  3. All saved comments show up on the right-hand side, as shown in the picture below.
How to open the comment history in Google Sheets

What can you do in the comment history?

The following (a) to (e) correspond to (a) to (e) in the screenshot below.

(a). Notification setting: Three options are available. “All comments” notifies you of all activities around comments (even if you are not directly involved or tagged in the comments). “Comments for you” will tell you only when you are tagged or mentioned in comments. If you choose “None”, you don’t receive any notification about comment activities.

(b). The scope of comments shown (Status): Four options are available. “All” make all types of comments visible in history. You can see only comments to you with the “For you” option. Only live threads are shown in the list with the “Open” option. The “Resolve” option allows you to see only resolved communications.

(c). The scope of comments shown (Sheet): You can select “All sheets”, which shows all comments across all sheets in a file, or “Current sheet”, which shows comments on the current worksheet.

(d). Three dots icon: Open a small pop-up where you can choose “Delete” or “Re-open” the thread. Also, the “Resolve” option is available for a live line.

(e). A comment box: You can enter your message in a thread. If you type in a text in a resolved and saved thread, the line will be reopened.

The actions you can take in the comment history

Other tips related to notes and comments

If you don’t get the right answer to your question in this article or you have other questions on notes and comments, you may find the answers in the following articles.

Comments

How to Add a Comment to a Cell in Google Sheets

How to Tag Someone in Google Sheets

Notes

How to Insert a Note in Google Sheets

Analyze your live financial data in a snap

Are you learning this tip to build a financial model or financial KPI dashboard by collaborating with others? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access other templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711