Real-time co-editing in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a project coordinator at a marketing agency.

📋 Request: Your manager wants a shared sales tracker that the whole team can update live during meetings.

📊 Data: You have monthly sales data from different regions and products. The data includes Region, Product, Month, and Sales Amount.

🎯 Deliverable: Create a Google Sheet that allows all team members to edit sales data simultaneously and see updates in real time.

Sample Data

Region	Product	Month	Sales Amount
North	Widget A	January	1200
South	Widget B	January	950
East	Widget A	February	1100
West	Widget C	February	700
North	Widget B	March	1300
South	Widget C	March	850
East	Widget B	April	900
West	Widget A	April	750

1

Step 1: Open Google Sheets and create a new spreadsheet named 'Team Sales Tracker'.

No formula needed.

Expected Result

A new blank Google Sheet named 'Team Sales Tracker' is ready.

2

Step 2: Enter the sample sales data into the sheet starting from cell A1 with headers: Region, Product, Month, Sales Amount.

No formula needed.

Expected Result

Sales data table is visible with correct headers and values.

3

Step 3: Share the Google Sheet with your team members by clicking 'Share' and adding their email addresses with 'Editor' access.

No formula needed.

Expected Result

Team members receive access and can edit the sheet simultaneously.

4

Step 4: Add a new column E with header 'Total Sales by Region' to calculate total sales per region dynamically.

=SUMIF(A:A, A2, D:D)

Expected Result

Each row in column E shows the total sales amount for the region in that row.

5

Step 5: Test real-time co-editing by asking a team member to update a sales amount in the sheet while you watch the changes live.

No formula needed.

Expected Result

You see the updated sales amount and recalculated totals immediately without refreshing.

Final Result

Team Sales Tracker

+--------+----------+---------+--------------+---------------------+
| Region | Product  | Month   | Sales Amount | Total Sales by Region|
+--------+----------+---------+--------------+---------------------+
| North  | Widget A | January | 1200         | 2500                |
| South  | Widget B | January | 950          | 1800                |
| East   | Widget A | February| 1100         | 2000                |
| West   | Widget C | February| 700          | 1450                |
| North  | Widget B | March   | 1300         | 2500                |
| South  | Widget C | March   | 850          | 1800                |
| East   | Widget B | April   | 900          | 2000                |
| West   | Widget A | April   | 750          | 1450                |
+--------+----------+---------+--------------+---------------------+

✓The sheet allows multiple users to edit sales data at the same time.

✓Total sales by region update automatically as data changes.

✓Real-time updates help the team track sales progress live during meetings.

Bonus Challenge

Create a live summary table that shows total sales per product updated in real time.

Show Hint

Use the SUMIF formula with the Product column as the criteria range and Sales Amount as the sum range.