Why Google Sheets is essential for collaboration - Dashboard Impact

Dashboard Mode - Why Google Sheets is essential for collaboration

Dashboard Goal

Understand how Google Sheets helps teams work together smoothly by showing live updates, comments, and shared data.

Sample Data

Task	Owner	Status	Comments	Last Updated
Design Logo	Alice	In Progress	Need feedback on colors	2024-06-01
Write Content	Bob	Completed	Reviewed by team	2024-05-30
Setup Website	Charlie	Not Started		2024-05-28
Test Features	Dana	In Progress	Found bugs in login	2024-06-02
Launch Campaign	Eve	Not Started		2024-05-29

Dashboard Components

• KPI Card - Tasks Completed: Shows how many tasks are done.
  Formula: =COUNTIF(C2:C6, "Completed")
  Result: 1
• KPI Card - Tasks In Progress: Shows tasks being worked on.
  Formula: =COUNTIF(C2:C6, "In Progress")
  Result: 2
• Table - Task Details: Displays all tasks with owner, status, comments, and last update.
• Formula - Latest Update Date: Shows the most recent update date.
  Formula: =MAX(DATEVALUE(E2:E6))
  Result: 2024-06-02
• Filter - Status: Dropdown to select task status to filter the table and KPIs.

Dashboard Layout

+----------------------+----------------------+
| Tasks Completed (KPI) | Tasks In Progress (KPI) |
+----------------------+----------------------+
|                      Task Details Table                      |
|                                                              |
|                                                              |
+--------------------------------------------------------------+
| Latest Update Date (KPI)                                     |
+--------------------------------------------------------------+
| Status Filter Dropdown                                       |
+--------------------------------------------------------------+

Interactivity

The Status Filter Dropdown lets you pick a status like "Completed" or "In Progress". When you choose a status, the Task Details Table updates to show only tasks with that status. The Tasks Completed and Tasks In Progress KPIs also update to count only tasks matching the filter. The Latest Update Date shows the newest update date among the filtered tasks. This live filtering helps teams focus on specific work stages and see real-time progress.

Self Check

If you set the Status Filter to "In Progress", which tasks appear in the table? What do the KPI cards show for completed and in-progress tasks? What is the latest update date shown?

Key Result

Shows task progress and updates live as team members collaborate using Google Sheets.