Introducing real-time collaboration in Sheets

Two people in the same spreadsheet used to mean one of them waiting. Sheets now shows who else is in the file and applies their edits as they happen, so the question "are you in it right now?" stops being part of the workflow. The mechanism is the same one behind collaboration in documents, applied to a grid rather than to a paragraph.

What live collaboration in Sheets does

• Presence: a count and list of the people currently in the sheet, so you know before you start typing.
• Cell-level updates: changes from other people appear in the grid as they are made, not when somebody saves.
• No save step — the file is already current for everyone looking at it.
• Each sheet has its own collaboration channel, so being in one file does not mean being visible in another.

What a grid makes harder than a document

Text is forgiving: two people writing in different paragraphs rarely interfere. A spreadsheet is not, because a cell is a single value and a formula can depend on a range somebody else is rewriting. The practical consequence is worth knowing — simultaneous edits to the same cell resolve to one value rather than merging, which is the correct behaviour and still surprises people. Split the work by area or by tab when several people are in at once, exactly as you would with a shared document that has one numbered list.

Presence is the feature people underuse. Glancing at who is in the file before restructuring a column costs a second and prevents the most annoying class of conflict, which is not lost data but two people doing the same reorganisation differently.

Working together without stepping on each other

1. Check presence before any structural change — inserting rows, renaming headers, rewriting a formula range.
2. Give each person a tab or a column block when the work is genuinely parallel.
3. Keep raw data and the summary on separate tabs so a layout change does not disturb the numbers somebody is reading.
4. Say what you are doing in a cell comment rather than assuming the other person can infer it.
5. Agree who owns the definitions, so two people do not fix the same figure in opposite directions.

Ettex Sheets ships presence and live cell updates per file. Where a spreadsheet is being edited by several people regularly, that is usually a signal the data wants a structure with fields and permissions rather than a grid — which is what a database for a small business is for, and the migration is easier before the sheet becomes load-bearing.