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 other users.
Use channels to share a note explaining why you changed the status of an opportunity in your team's CRM workbook, to detail the next steps you will take with a bug in your team's bug tracker, or send a message @ a user to welcome them to your team's project tracker.
Topics in this Article:
- Workbook, Row, and Cell Channels
- Types of Channel Messages
- Editing and Deleting Messages
Workbook, Row, and Cell Channels
Each workbook has three levels of channels: the Workbook channel, the Row channel, and the Cell channel. The linked articles cover how messages in each channel work. But for all channels, users must have the permission level of "Commenter" or higher to be able to comment in a workbook. On channels, all content is displayed in reverse chronological order with the newest messages at the bottom.
The Workbook Channel
At the highest level is the workbook channel which can be accessed from any worksheet or view within the workbook. The Workbook channel contains an audit log of added users and is used to collaborate with others about the workbook at large.
The workbook channel can be accessed via the workbook messages icon in the top right of your worksheet.
See the Workbook channel article for more details.
The Row Channel
In individual worksheets, it is possible to add messages, @mentions, replies, and more to rows of data. As rows can be expanded to show all information in that row or related across worksheets, the row channel is crucial to collaborate.
Rows with messages currently in them will be denoted by a yellow message flag in the top right corner of the row header for that row. You can access the row channel by expanding a row.
See the Row Channel article for more details.
The Cell Channel
The cell channel allows you to comment on the data in a specific cell. 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 listed 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.
Like the row channel, cells with messages are demarcated by a yellow flag in the top right corner.
Types of Channel Messages
You can add 5 types of messages to a channel: comments, @mentions, replies, emojis, or reactions.
To add a comment, use the text box at the bottom of the workbook channel dialog. Also, the text box is where you can type or paste in text, use @mentions, replies, emojis, or reactions.
@mentions allow you to talk to a specific user that already has access to the workbook. @mentions notify users (via email) that they have been mentioned, share the message, and the sender with that user.
To @mention a user, type the @ symbol which will popup a list of workbook user, 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 as a part of your comment.
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.
Emojis can also be added to messages through the autosuggest function, which should be familiar if you’ve used Slack or similar collaboration tools.
While writing a message within a channel, type a colon (:) followed by an emoji name and select the corresponding emoji. You can select the emoji by clicking on its name, or by pressing Enter on your keyboard.
Spreadsheet.com uses the same emoji shortcodes as Slack, GitHub, and Basecamp. You can see the list of every emoji’s corresponding shortcode here.
Reactions are like emojis but in direct response to a message. There can be multiple different 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.
In the animation below, we feature multiple types of messages. Lisa reacts to Aaron's message, replies, adds a new comment, writes an @mention to Roger, and adds an 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.
|Workbook 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
|Cannot see the workbook 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.
For more details about the individual channels, see our articles on the Workbook Channel, Row Channel, and Cell Channel. Or see our other Collaboration and Sharing articles for details on permissions levels, @mentions, and more.