Real-time co-editing in Google Sheets - Dashboard Guide

Dashboard Mode - Real-time co-editing

Goal

See how multiple people can work together on the same Google Sheet at the same time and track changes live.

Sample Data

Task	Owner	Status	Due Date
Write report	Alice	In Progress	2024-06-10
Design slides	Bob	Not Started	2024-06-12
Review budget	Charlie	Completed	2024-06-08
Plan event	Alice	In Progress	2024-06-15
Send invites	Bob	Not Started	2024-06-14

Dashboard Components

• Live Task List: Shows the tasks with current owners and status. Updates instantly as collaborators edit cells.
• Status Summary: Uses =COUNTIF(C2:C6, "Completed") to count completed tasks and =COUNTIF(C2:C6, "In Progress") for tasks in progress.
• Owner Filter: A dropdown filter to select an owner and show only their tasks using =FILTER(A2:D6, B2:B6=G1) where G1 is the selected owner.

Dashboard Layout

+----------------------+------------------+
| Live Task List       | Status Summary   |
| (Tasks, Owner, Status| (Completed,      |
| Due Date)            | In Progress)     |
+----------------------+------------------+
| Owner Filter Dropdown                   |
+---------------------------------------+

Interactivity

The Owner Filter dropdown lets you pick a person. When you select an owner, the Live Task List updates to show only tasks assigned to that owner. The Status Summary always shows counts for all tasks, updating live as anyone edits task statuses.

Self Check

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

• The Live Task List updates to show only Alice's tasks.
• The Status Summary remains unchanged and shows counts for all tasks.

Key Result

A live task tracker showing real-time updates and filtering by owner in Google Sheets.