Spreadsheet.com is designed for collaboration and provides channels where you can work with your team. A Channel is a place where you can send messages to users.
Spreadsheet.com workbooks have channels at three levels: the Workbook level, the Row level (which is covered in this article), and the Cell level. The linked articles cover how messages in the workbook and cell 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.
Use the row channel to ask questions about a specific opportunity in your team's CRM workbook, to note the next steps you will take with a bug listed in your team's bug tracker, or send a message @ another user for them to respond.
Topics in this Article
- The Row Channel
- How to add a message to the Row Channel
- Types of messages
- Editing and Deleting Messages
The Row Channel
You can use the row channel to collaborate on data in that row. For instance, in your project plan, ask users about how a particular task is going, when it's expected to be completed, if they need help, and more. The row channel also shows messages from the cell channels of all the cells in that row.
You can tell if a row or cell already has messages in it via a visible flag that will appear in the top-right of the row header or the top-right corner of a cell. For instance, in the image below, both row 8 and cell C8 have comments.
To view the row channel, expand the desired row. Expand rows by selecting the desired row, right-clicking on the row header, and selecting Expand row. Or use the row expander in the row header .
In the expanded row view, messages are shown in the row channel and are displayed in chronological order from top-down. Scroll up to view past messages.
How to add a message to the Row Channel
To add a message, first open the row channel by expanding the row, then use the message text box at the bottom of the row channel dialog. Here you can type or paste in text, use @mentions, replies, emojis, or reactions.
Types of messages
@mentions allow you to talk to a specific user that has access to your workbook. @mentions notify users (via email) that they have been mentioned, share the message, and the workbook with that user.
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.
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.
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, users 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 any user's comments. These features are determined by permission level, as defined below.
|Row Channel Permissions
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 the row channel.|
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.
If you want to make a comment that will appear across all worksheets and views or about the workbook generally, try a workbook message. Or, to get even more specific, you can add messages to specific cells that will appear in the expanded row.