Data-level comments

Data-level commentary is very common in real-life scenarios. In this section, we'll see how you can add data-level comments, mention other users, reply to comments and receive instant notifications on replies/mentions.

While all comments can be written back to databases or shared drives, only the comment column can be exported to an Excel/PDF file.

1. Add comments

You can add formatted data-level comments which are saved securely to the database along with details such as author and time stamp.

a) Select a cell/row/column. The 'Add a comment' icon gets enabled. Click on the icon.

Adding a data-level comment

b) The comments editor opens up. Enter a comment as shown below.

Comment editor

c) Let's apply some formatting to 'margins'. Select the text, click on the 'Font color' icon and select a color from the color picker.

Changing text color

d) The font color gets updated. Let us now add a hyperlink to 'document'. Select the text and click on the 'Link' icon.

Adding hyperlink

e) Enter an URL as shown and click 'Apply'.

Adding hyperlink

f) The hyperlink gets added. Click 'Post'.

Posting a comment

g) The comment gets added. You can see a blue indicator on the top right corner of the cell. There are a number of options in the comment box which we'll be covering in the other sections.

Comment gets posted

h) You can edit/delete a comment added by you as shown. Report authors/editors can edit/delete comments added by other users as well.

Edit/delete a comment

i) To hide comments temporarily, turn on the 'Hide all comments' toggle.

Hide all comments

j) All the comments are hidden.

All comments get hidden

k) Certain comments can be locked to prevent editing and replies. Click on the 'Three dots' icon and click on 'Lock thread' highlighted below.

Comments can be locked

l) The comment thread gets greyed out. To unlock the thread, click on the 'Unlock' icon.

Locked comments can be unlocked

m) To delete all comments, in the 'Comments' dropdown, select 'Settings'. In the side panel, in the 'General' tab, click 'Delete all comments'.

Delete all comments

2. Mention other users

You can use @ symbol to tag other stakeholders and draw their attention​.

a) Click on a cell and 'Add a comment'. Type @ in the comment editor. You will see a list of the users in the workspace.

Using @mentions

b) Select the desired user, add the comment and click 'Post'.

Mention other users

c) The comment gets posted successfully.

Comment posted successfully

3. Reply to comments

Users can reply to comments posted by others and have interactive conversations.​​

a) Click on 'Reply'.

Reply to comments

b) Enter the reply in the comments editor and click 'Reply'.

Reply added

c) The comment reply gets added as a thread.

Threaded comments

4. Comments column

You can add a dedicated comments column to capture row-level comments.

a) In the 'Comments' dropdown, turn the 'Comments column' toggle on.

Turn on comments column

b) The comments column gets added.

Comments column gets added

c) Click on any cell in the comments column. The comment editor opens. Enter a comment and click 'Post'.

Entering a comment in the comments column

d) The comment gets added as shown in the below image.

Comment gets added

e) To reply to a comment in the comments column, simply click on the comment and 'Reply'.

Comments column supports replies

f) The number of replies is also shown along with the comment.

Comment along with number of replies

g) To hide the comments column, turn off the toggle.

Hide comments column

5. Roll-up comments

In reports with large number of hierarchies, you can see comments rolled up at the subtotal and grand total level even if the hierarchies are collapsed. This enables executives to see collapsed and summarized reports but still see exception comments rolled up at the parent levels.

In the below image, comments are added at the product category and sub category levels which are consolidated and shown at the region level.

Roll-up comments in parent level cells

Roll-up comments work in the Comments column too. In the image below, comments are added at the product category, sub category and sub-region levels which are consolidated and shown at the region level.

Roll-up comments in Comments Column

To turn on roll-up comments, turn on the 'Rollup indicator' toggle in the 'Comments' dropdown.

Roll-up indicator

6. Email notifications

The ‘@user’ mention in the comment automatically sends an email notification to the user, with a link to the report so that the user can respond to this comment and/or update the report. Replies to the comments are also notified to the user instantly.

Email notification on mentioning user

a) Email notifications on comment replies can be turned off. In the dropdown highlighted, click on 'Profile settings'. In the side panel, turn off the toggle.

Turn off email notifications on comment replies

b) Email notifications for new replies or mentions can be turned off. In the 'Settings' panel, uncheck the highlighted checkbox.

Turn off email notifications for new reply and mention

In the next section, we'll see how you can assign & track tasks.