Commenting and collaboration features enable you to add contextual discussions directly within the PowerTable sheet. Use these capabilities with your team to collaborate, review data, provide feedback, assign tasks, and track discussions all within the table.
Use comments to add context or discussions to a specific cell, row, or column in the table.
To add row-level comments, set up the comments column.
To add comment to a cell or a column,
A green triangle appears in the top corner of the cell, indicating that the cell contains a comment. The comment is saved with metadata such as the author name, timestamp, and, if applicable, the assigned user.
To make a comment important, select the star icon
to make it a starred comment.
When you assign a comment to a user, PowerTable sends them a Microsoft Teams notification. The notification includes the PowerTable sheet name, the comment's cell location, the assigner's name, the comment text, and a link to the PowerTable sheet.
The assigned user can then take action or reply to the comment.
In addition to assigning a user by using Assign to user, you can notify more users by using @ and mentioning them in the comment. Comments with mentions help you assign and track tasks for effective workflow collaboration.
Mentioned users also receive Teams notifications with all the comment details and a link to the sheet so they can respond or take action.
The task status is initially Open and can later be updated to Resolved when the task is completed.
Comments support threaded conversations that allow multiple users to collaborate.
Replies appear as part of the same comment thread, making it easier to track discussions.
You can manage comment threads to control discussions.
To resolve a thread,
You can reopen a resolved thread if further discussion is needed. Reopen the thread by selecting the undo icon or by replying to the thread.
You can add a separate Comments column in the sheet to capture row-level discussions.
To add a comments column:
Comments in the Comments column support replies, user assignments, and task status tracking.
When you assign or mention a user in a comment, PowerTable automatically adds the Status and Assignee columns. The Assignee column displays the assigned user, and the Status column displays the current status of the assigned comment, such as Open or Resolved.
To show or hide the Assignee and Status columns, select the > icon in the Comments column header.
To remove the Comments column, turn off the Show comments column toggle in the Comment Settings panel.
You can view all row-level comments in the All Comments panel under Row Comments.
You can view all comments in a centralized panel to track discussions across rows, columns, and cells.
Select View all comments from the Comments dropdown. The All Comments panel opens.
Comments are organized by category, along with the number of comments in each category:
Expand each section by selecting > to view the associated comments.
You can customize how you want to display comments and configure notification settings.
To open the Comment Settings pane, select the Comments dropdown, and then select Settings.
The following options are available:
Finally, select Save to apply the changes made in the Comment Settings pane.
Note
Deleting all comments permanently removes all comment threads from the table. This action cannot be undone.
You can control who can access, manage, and interact with comments using the Security settings.
Manage comment access
Use the following options to define access:
Who can add comments
Specify users who can add comments. Enter names or email addresses to grant access.
Select Save Changes to apply changes.
Note
Report authors and editors can delete comments from other users, such as, inappropriate comments.
