Resolve a comment in Google Sheets
This is a notification-free comment register. Resolve the B4 comment by changing only C2 from "Open" to exactly "Resolved". Do not create or resolve an actual Google comment, and keep the D7 row unchanged.
Verified by PhilisAbout 60 secondsThis is a notification-free comment register. Resolve the B4 comment by changing only C2 from "Open" to exactly "Resolved". Do not create or resolve an actual Google comment, and keep the D7 row unchanged.
Step-by-step
Select the targetThis is a notification-free comment register.
Apply the changeResolve the B4 comment by changing only C2 from "Open" to exactly "Resolved".
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
The B4 register entry is resolved and the D7 entry remains open.
Common mistake
Applying the change to more rows, columns, or cells than the task specifies.
Troubleshooting
Re-select B4 and repeat the final action. The B4 register entry is resolved and the D7 entry remains open.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Cell | Comment | Status |
| B4 | Confirm the launch date | Open |
| D7 | Check the campaign total | Open |
Video transcript
- Open the prepared Resolve comment spreadsheet.
- Select the target. This is a notification-free comment register.
- Apply the change. Resolve the B4 comment by changing only C2 from "Open" to exactly "Resolved".
- The B4 register entry is resolved and the D7 entry remains open.