Edit history and version control in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a project coordinator managing a shared Google Sheet for a team.

📋 Request: Your manager wants you to track changes made to the sheet over time and be able to restore previous versions if needed.

📊 Data: You have a shared Google Sheet with project tasks, assigned team members, deadlines, and status updates.

🎯 Deliverable: Create a system to view edit history, label important versions, and restore previous versions when necessary.

Sample Data

Task ID	Task Name	Assigned To	Deadline	Status
1	Design Logo	Alice	2024-06-10	In Progress
2	Write Content	Bob	2024-06-15	Not Started
3	Develop Website	Charlie	2024-06-20	Not Started
4	Test Website	Dana	2024-06-25	Not Started
5	Launch Campaign	Eve	2024-06-30	Not Started

1

Step 1: Open the Google Sheet and click on 'File' in the menu.

No formula needed.

Expected Result

You see the File menu options.

2

Step 2: Select 'Version history' then 'See version history'.

No formula needed.

Expected Result

A panel opens on the right showing all saved versions with timestamps and editors.

3

Step 3: Click on the three dots next to a version and select 'Name this version'.

No formula needed.

Expected Result

You can enter a descriptive name like 'Before major update'.

4

Step 4: Make some changes to the sheet, for example, update the status of Task ID 1 to 'Completed'.

Change cell E2 from 'In Progress' to 'Completed'.

Expected Result

The status for Task ID 1 updates to 'Completed'.

5

Step 5: Return to 'Version history' and name this new version 'Task 1 completed'.

No formula needed.

Expected Result

The new version is saved with the name 'Task 1 completed'.

6

Step 6: To restore a previous version, open 'Version history', select the desired version, and click 'Restore this version'.

No formula needed.

Expected Result

The sheet reverts to the selected version, undoing later changes.

7

Step 7: Share the sheet with your team and remind them to use version history to track changes and restore if needed.

No formula needed.

Expected Result

Team members can view and restore versions, improving collaboration and safety.

Final Result

Google Sheets Version History Panel
-----------------------------------
| Version Name          | Date       |
|-----------------------|------------|
| Initial version       | 2024-06-01 |
| Before major update   | 2024-06-05 |
| Task 1 completed      | 2024-06-07 |
-----------------------------------

Sheet shows Task 1 status as 'Completed' in latest version.

✓Version history lets you see who changed what and when.

✓Naming versions helps find important points quickly.

✓Restoring versions can undo mistakes easily.

✓Sharing with version control improves teamwork.

Bonus Challenge

Create a separate sheet that logs changes automatically using Google Apps Script.

Show Hint

Use the onEdit() trigger in Apps Script to record edits with timestamp, user, and changed cell.