Comments and suggestions in Google Sheets - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants you to collect feedback from the team on the monthly campaign report. They want you to add comments and suggestions directly in the Google Sheet so everyone can see and respond.

📊 Data: You have a Google Sheet with the monthly campaign data including columns for Campaign Name, Start Date, End Date, Budget, and Results.

🎯 Deliverable: Add comments and suggestions to specific cells in the sheet to highlight areas needing feedback or improvement.

Sample Data

Campaign Name	Start Date	End Date	Budget ($)	Results ($)
Spring Sale	2024-03-01	2024-03-31	5000	7500
Summer Launch	2024-06-01	2024-06-30	7000	6800
Back to School	2024-08-15	2024-09-15	6000	9000
Holiday Promo	2024-12-01	2024-12-31	8000	12000
Winter Clearance	2024-01-10	2024-01-31	4000	3500

1

Step 1: Open the Google Sheet with the campaign data.

Expected Result

You see the table with campaign names, dates, budgets, and results.

2

Step 2: Select the cell with the 'Summer Launch' campaign's Results ($6800).

Expected Result

Cell with 6800 is selected.

3

Step 3: Add a comment to this cell by right-clicking and choosing 'Comment'. Type: 'Results are below budget. Any ideas to improve?' and click 'Comment'.

Expected Result

A small orange triangle appears in the top-right corner of the cell indicating a comment.

4

Step 4: Select the 'Winter Clearance' campaign's Results cell ($3500). Add a suggestion by right-clicking and choosing 'Suggest edit'. Type: 'Consider increasing budget for better reach.' and save the suggestion.

Expected Result

The cell shows a suggestion indicator and the suggestion is visible to collaborators.

5

Step 5: Review all comments and suggestions by clicking the comment icon in the top-right corner of the sheet to open the comment thread panel.

Expected Result

All comments and suggestions are listed for easy review and reply.

6

Step 6: Reply to the comment on 'Summer Launch' by clicking it and typing: 'We will analyze ad channels for better targeting.'

Expected Result

Your reply is added to the comment thread.

Final Result

Campaign Name | Start Date | End Date   | Budget ($) | Results ($) 
--------------|------------|------------|------------|------------
Spring Sale   | 2024-03-01 | 2024-03-31 | 5000       | 7500       
Summer Launch | 2024-06-01 | 2024-06-30 | 7000       | 6800*      
Back to School| 2024-08-15 | 2024-09-15 | 6000       | 9000       
Holiday Promo | 2024-12-01 | 2024-12-31 | 8000       | 12000      
Winter Clearance | 2024-01-10 | 2024-01-31 | 4000       | 3500#      

* Comment: "Results are below budget. Any ideas to improve?"
# Suggestion: "Consider increasing budget for better reach."

✓The 'Summer Launch' campaign results are below the budget, prompting a comment for improvement ideas.

✓A suggestion was made to increase the budget for the 'Winter Clearance' campaign to improve results.

✓Comments and suggestions help the team communicate directly in the sheet for better collaboration.

Bonus Challenge

Create a summary sheet that lists all cells with comments or suggestions and their content for quick review.

Show Hint

Use the Google Sheets 'Comments' menu or explore Google Apps Script to extract comments and suggestions automatically.