Comments and suggestions in Google Sheets - Dashboard Guide

Dashboard Mode - Comments and suggestions

Goal

Help a team track feedback on project tasks by adding comments and suggestions directly in the spreadsheet. This dashboard shows tasks, their status, and any comments or suggestions from team members.

Sample Data

Task ID	Task Name	Status	Assigned To	Comments
1	Design Homepage	In Progress	Alice	Consider using a lighter color scheme.
2	Setup Database	Completed	Bob	Optimized queries for speed.
3	Write Content	Not Started	Charlie
4	Test Features	In Progress	Dana	Found some bugs in login flow.
5	Deploy Site	Not Started	Eli

Dashboard Components

• KPI Card: Total Tasks
  Formula: =COUNTA(A2:A6)
  Shows total number of tasks.
• KPI Card: Completed Tasks
  Formula: =COUNTIF(C2:C6, "Completed")
  Counts tasks marked as Completed.
• Table: Task List with Comments
  Shows all tasks with their status and comments for easy review.
• Filter: Status Filter
  Uses Data Validation dropdown on cell G1 with options: All, Not Started, In Progress, Completed.
  Formula to show filtered tasks:
  =FILTER(A2:E6, (G1="All")+(C2:C6=G1))

Dashboard Layout

+----------------------+----------------------+
| Total Tasks (KPI)    | Completed Tasks (KPI) |
+----------------------+----------------------+
| Status Filter [G1]                         |
+-------------------------------------------+
| Task List with Comments (Filtered Table)  |
|                                           |
|                                           |
+-------------------------------------------+

Interactivity

The Status Filter dropdown lets users select a task status or 'All'. When a status is selected, the Task List table updates to show only tasks with that status. The KPI cards always show totals for all tasks, regardless of filter.

Self Check

If you select "In Progress" in the Status Filter, which tasks appear in the Task List? What is the count of Completed Tasks KPI?

Key Result

Dashboard to track project tasks with comments and filter by status in Google Sheets.