In this article, you will learn what you can do with the Comment History in Google Sheets.
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.
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.
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.
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.
Learn how to do this step-by-step in the video below 👇