Why collaboration is Sheets' superpower in Google Sheets - Dashboard Impact

Dashboard Mode - Why collaboration is Sheets' superpower

Goal

See how multiple team members contribute to a project tracker in real-time and track progress together.

Sample Data

Task	Owner	Status	Hours Spent	Last Updated
Design Homepage	Alice	In Progress	5	2024-06-01 10:15
Write Content	Bob	Completed	3	2024-06-01 09:50
Setup Analytics	Charlie	Not Started	0	2024-05-31 16:30
Test Signup Flow	Alice	In Progress	2	2024-06-01 11:00
Deploy Site	Bob	Not Started	0	2024-05-31 15:00

Dashboard Components

• KPI Card: Total Tasks
  Formula: =COUNTA(A2:A6)
  Shows total number of tasks (5)
• KPI Card: Completed Tasks
  Formula: =COUNTIF(C2:C6, "Completed")
  Shows how many tasks are done (1)
• KPI Card: Total Hours Spent
  Formula: =SUM(D2:D6)
  Sum of hours spent on all tasks (10)
• Table: Tasks by Owner
  Formula for Alice's tasks count: =COUNTIF(B2:B6, "Alice")
  Shows how many tasks each person owns:
  Alice: 2, Bob: 2, Charlie: 1
• Last Updated Timestamp
  Formula: =MAX(E2:E6)
  Shows the most recent update time (2024-06-01 11:00)

Dashboard Layout

+----------------------+----------------------+----------------------+
| Total Tasks (5)      | Completed Tasks (1)  | Total Hours (10)     |
+----------------------+----------------------+----------------------+
| Tasks by Owner       | Last Updated: 2024-06-01 11:00               |
| Alice: 2             |                                              |
| Bob: 2               |                                              |
| Charlie: 1           |                                              |
+----------------------+----------------------------------------------+

Interactivity

Use a filter dropdown to select an Owner (Alice, Bob, Charlie). When selected, all KPI cards and the tasks table update to show data only for that person. This shows how collaboration progress is tracked per team member.

Self Check

If you filter to show only tasks owned by Alice, which components update?

• Total Tasks changes to 2
• Completed Tasks changes to 0
• Total Hours Spent changes to 7 (5+2)
• Tasks by Owner shows only Alice: 2
• Last Updated shows 2024-06-01 11:00 (latest for Alice's tasks)

Key Result

A project tracker dashboard showing task counts, completion, hours, and last update with owner-based filtering to highlight collaboration.