In this article:

Difference Between Google Sheets Notes vs Comments in 2024

google sheets notes vs comments

Google Sheets Notes Explained

Notes in Google Sheets are primarily used for adding additional information or context to a cell. They are non-interactive, meaning they are designed for one-way communication without the expectation of a response or discussion.

Key Features of Google Sheets Notes

Non-Interactive: Notes serve as simple annotations attached to cells. They are intended for adding extra information or context. Users can view a note by hovering over the cell.

Visibility: Notes are displayed as a small, colored triangle in the corner of a cell. They are visible to anyone with access to the spreadsheet but are less prominent and do not prompt user interaction.

No Notification: Adding or editing a note does not send notifications to other users. This makes notes suitable for passive information that does not require immediate attention.

Single Layer: Notes are straightforward annotations without the ability to reply or create a thread. They are best used for static information, explanations, or quick reminders.

google sheets comments vs notes

Google Sheets Comments Explained

Google Sheets comments offer a dynamic and collaborative layer to spreadsheets, making them an essential tool for teams and projects that require communication and task management within the document.

Key Features of Google Sheets Comments 

Interactive: Comments are designed for collaboration and communication. They allow users to mention others with "@name," triggering an email notification to the mentioned user. This feature facilitates active discussions and feedback directly within the spreadsheet.

Threaded Conversations: Comments support replies, allowing for a threaded conversation within a cell. This enables a back-and-forth discussion that is directly linked to specific data or analysis within the spreadsheet.

Notification System: Users receive notifications for new comments and replies, especially if they are mentioned directly. This ensures that users are promptly informed of discussions relevant to them, enhancing collaboration.

Actionable: Comments can be resolved, acting as tasks or issues that can be marked as completed. This feature helps teams track the progress of feedback or action items directly within their workflow.

Google Sheets Comments vs Notes: What's the Difference?

Interactivity

Comments: Interactive, designed for collaboration, allowing users to mention others, receive notifications, and engage in threaded discussions.

Notes: Non-interactive, meant for adding supplementary information or context to a cell without initiating a dialogue.

Visibility and Notification

Comments: Displayed with a small yellow indicator in the cell's corner and can assign tasks and send notifications to users.

difference between google sheets notes and comments

Notes: Displayed with a small black indicator in the cell's corner, no notifications sent upon addition or edit.

google sheets notes and comments difference

Purpose and Use Case

Comments: Suited for dynamic interaction, such as asking questions, providing feedback, or discussing data within the spreadsheet. 

Notes: Ideal for static information like clarifications, definitions, or additional details that do not require feedback.

Tracking and Resolution

Comments: Can be resolved, which hides the comment from the default view, helping teams track issues, feedback, or tasks and their resolution status.

Notes: Cannot be "resolved" or tracked; they remain in the spreadsheet until manually removed or edited.

We hope that this article has helped you and given you a better understanding of the difference between Google Sheets notes vs comments. If you enjoyed this article, you might also like our articles on how to show comments in Google Sheets and how to use the FLATTEN function in Google Sheets.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started