How can I tell which collaborator changed a schedule entry and when?
Quick answer
First identify the spreadsheet service and open the schedule entry’s own edit history, if available. In Google Sheets on a computer, right-click a cell and choose “Show edit history” to inspect changes to that cell. You can also review spreadsheet version history for earlier versions, who updated the file, and their changes. Access and detail may be limited, so record what the history actually shows rather than treating it as a complete audit. [S1]
The question, the details, the next step.
A shared schedule entry changed, and I need to work out who changed it and when. What should I check first?
Start with the spreadsheet service and the specific entry you are investigating. If the schedule is in Google Sheets on a computer, right-click the relevant cell and select “Show edit history.” That view lets you inspect changes to that particular cell. Google Sheets also has spreadsheet version history, which shows earlier versions, who updated the file, and their changes. [S1]
Treat these as two different views: cell history focuses on one cell, while version history concerns earlier versions of the file. Note the schedule date and the cells involved before opening the history. This helps you compare the record with the entry without guessing which change matters.
The schedule is in Google Sheets. How do I check the exact entry without overlooking the time or the person?
On a computer, right-click the cell containing the changed schedule information and choose “Show edit history.” Review the details displayed, and write down only what the view provides—for example, the cell you checked, the displayed editor, and any displayed time information. The available guidance confirms that this feature lets you inspect changes to a particular cell; it does not specify a particular time format or guarantee that every change will have a visible timestamp. [S1]
If the entry spans multiple cells—for example, date, shift, and assigned person—check each relevant cell rather than assuming one cell’s history covers the whole entry. Keep your notes factual: “This cell’s history displays…” is more precise than “This person changed the entire schedule.”
What if the cell history looks empty or doesn’t explain what happened?
Check spreadsheet version history as a second route. Google says it can show earlier versions, who updated the file, and their changes. Appropriate access to the file is required, and the information available can be incomplete. [S1]
Cell edit history may omit inserted or deleted rows and columns, formatting changes, formula-driven changes, and edits made before restoring an earlier version. [S1] So an apparently blank or partial cell history does not establish that the schedule was untouched. It also does not, by itself, identify why an entry changed. If you cannot access the relevant history, ask the file owner or administrator what history is available to you; do not infer an editor from the current value alone.
The schedule might be in another spreadsheet service, or I need to report what I find. What’s a careful way to handle that?
Do not assume Google Sheets’ controls or history limits apply to another service. Check that service’s own help or settings for entry-level history and file-level activity or version history. Verify what each view records, what access is needed, and whether it shows the person, time, and specific change you need. The Google guidance here applies to Google Sheets, not other spreadsheet services. [S1]
For a concise report, use a note like this:
“File/service: [name]. Schedule entry: [date and relevant cell(s)]. View checked: [cell history / version history / other]. Displayed editor: [as shown / not shown]. Displayed time: [as shown / not shown]. Displayed change: [brief description]. Limits or gaps: [what could not be confirmed].”
This separates what the record displays from what remains uncertain. The available guidance does not establish that every spreadsheet service keeps the same history, that every edit is recorded, or that a displayed record will answer every question.
A practical checklist
Identify the spreadsheet service and the schedule file you are checking.
Pinpoint the affected date and each relevant cell in the entry.
Open the service’s cell-level edit history, if available, and note only displayed details.
Review file-level version or activity history as a separate view; check whether you have access.
Record missing details and possible history gaps instead of inferring who made an unexplained change.
A few more useful answers
Does Google Sheets cell edit history show every kind of change?
No. Google says it may omit inserted or deleted rows and columns, formatting changes, formula-driven changes, and edits made before restoring an earlier version. [S1]
Can I use these steps for any spreadsheet service?
The cell-history steps described here are for Google Sheets on a computer. Check another service’s own documentation and settings rather than assuming its history works the same way. [S1]
What if I cannot open version history?
Google says appropriate file access is required for version history. Ask the file owner or administrator what history is available to you, and report any details you could not confirm. [S1]
Sources
References used for this guide.
- [S1] Find what changed in a Google file, including a spreadsheet cell support.google.com · Checked