Spreadsheet.com is designed for collaboration and provides channels where users can work on teams. A Channel is a place where you can send messages to users.
Use the cell channel to ask questions or make comments about the data in a cell. For instance, ask if there is an update on the status of an opportunity in your team's CRM workbook, explain why you downgraded the severity of a bug in your team's bug tracker, or send a message @ a user about an upcoming deadline on the team's project plan.
Spreadsheet.com workbooks have channels at three levels: the Workbook level, the Row level, and the Cell level (covered in this article). The linked articles cover how messages in the workbook and row channels work. But for all channels, users must have the permission level of "Commenter" or higher to comment in a workbook. On channels, all content is displayed in reverse chronological order with the newest messages at the bottom.
Topics in this Article
The Cell Channel
In addition to the workbook-wide and row channels, cell channels allow you to send and receive messages. The specificity of cell messages allows you to collaborate around the data inputted into specific cells.
A cell with an existing message will display a flag or dog-ear icon in the top right corner of the cell.
To access a cell channel, right-click on the cell and choose Cell Messages.
Messages are shown in chronological order from top-down in the message pane. Users can scroll up to view past messages.
To add a message, use the message text box at the bottom of the channel dialog. A comment can be any combination of text, @mentions, replies, emojis, and reactions (all of which are detailed below). Also, all cell channel messages appear in the row channel, which can be accessed by expanding the row.
Types of messages
@mentions allow you to talk to a specific user that already has access to the workbook. @mentions notifys users (via email) that they have been mentioned, shares the message, and the workbook.
To @mention a user, type the @ symbol which will popup a list of workbook users and either type or select their name. Or you can use the @ mention feature in the bottom right. Both of these ways of @mentining a user are demonstrated in the animation below.
Users can directly reply to messages using the reply feature that appears when you mouse over a message. Replies include the message that's being replied to, but not the whole chain of replies, and notify the most recent author of your reply.
To reply to a comment or message, mouse over the comment and select the Reply option. The previous message will then appear above your text box and in your comment when you press enter. In the animation above, we reply to Lisa's comment before @ mentioning Peter and Roger.
You can add emojis to the channel or include them inside your message with the emoji selector in the bottom right of the message panel.
From the emoji selector panel, you can pick an emoji to add, scroll or tab between categories of emojis, change the skin tone of the emojis, or search for an emoji.
The animation below shows these emoji features in the workbook channel, but they are the same for the row and cell channels.
Reactions are like emojis but in direct response to a message. There can be multiple reactions to a given message, and users can vote up an existing reaction.
To add a reaction to a message, hover over to the desired message, and select the "Add reaction" emoji.
Editing and Deleting Messages
In addition to replies and reactions, some users can edit their comments or delete the comments of any user. These features are determined by permission level, as defined below.
Owners, Managers, and Collaborators
Can react and reply to any message.
Editor and Commenter
Can react and reply to a message.
Cannot delete any messages
|Can view but not add to cell channels.|
Edit: To edit one of your own messages, hover over your message, and select the edit button.
Delete: to delete one of your messages or to moderate another's message, hover over the message, and select the delete button.
Check out our article on the Workbook channel if you wish to send users comments about elements in the entire workbook, or our article on the Row channel for comments that pertain to all of the data in a row.