Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

Staff keep overwriting each other's work in a shared Google Sheet

Short answer

In a shared sheet, anyone with edit access can overwrite any cell, and a sheet cannot say who owns a record. Use version history and cell edit history to trace the damage, protect ranges so each person edits their own area, and give each task its own tab or file.

  • Written for business owners
  • Updated
  • By Maaz Zindani, Senior Software Engineer

Does this sound like your situation?

  • Someone's entry disappeared and nobody remembers deleting it.
  • Two people updated the same row and one version won.
  • Nobody knows who last changed a price or a status.
  • People keep their own copies 'to be safe'.
  • Sorting or filtering by one person confuses everyone else.

Why does this happen?

  1. Everyone with edit access can change everything

    Google's roles are Editor, Commenter and Viewer. An editor can make changes to the spreadsheet, so a shared sheet has no built-in notion of one person owning one record.

  2. No areas are protected

    Google lets owners and editors protect a sheet or a range, choose who may edit it, or show a warning that must be confirmed first. If this was never set, nothing separates one person's rows from another's.

  3. Shared sorting and filtering

    Sorting a range or deleting rows changes the file for everyone. A change that is harmless for one person can scramble another person's work.

  4. Tracing the change is limited

    Version history shows who changed what, and cell edit history shows previous values, but Google says some changes do not appear, including added or deleted rows and columns and changes made by formulas.

  5. One sheet doing several jobs

    When one tab is used for data entry, review and reporting by different people, collisions are expected.

What can I do about it today?

  1. Find the lost data firstOpen version history, look at earlier versions and copy back what was lost. Make a copy of a good version rather than restoring over the current one, since restoring clears the earlier cell-by-cell history.
  2. Right-click a doubtful cellChoose Show edit history to see previous values and who changed them.
  3. Give each person an areaProtect ranges so each person or team can edit only theirs. Choose the warning option first if people need time to adjust.
  4. Use views for sortingAsk people to use the filter views feature or a separate copy for their own sorting, not the shared one.
  5. Review who has edit accessOpen Share and change people who only need to look to Viewer. Removing edit access is reversible.

When should I bring someone in?

  • Lost data cost you money or a customer.
  • More than a handful of people must enter data at the same time.
  • You need an audit trail of every change.

How do I handle it?

  1. Observe how people actually workI look at who enters what, when, and where collisions occur.
  2. Restructure the sheetEntry, calculation and reporting are separated, with one row per record and one owner per area.
  3. Protect and logRanges are protected by role, and a change log is kept for the critical fields.
  4. Replace the entry step with a formEntries go through a form that adds a new row each time, which removes most overwriting.
  5. Move to software if it keeps growingWhen many people edit the same records, a small application with accounts and a change history is the lasting fix.

The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.

What do owners ask about this?

Can I stop people overwriting without blocking them?

Yes. Protection can be set to show a warning that must be confirmed, which slows accidents without locking anyone out.

Can I see everything that ever changed?

Not completely. Google lists some changes, such as added or deleted rows and columns, as not shown in cell edit history.

Is there a related page on sensitive data in sheets?

Yes, the help page on Google Sheets permissions and sensitive data.

Sources

How was this page made?

I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.

Next step

Want this off your desk?

Send me a few lines on where things stand. I reply within 24 hours.