CODEWITHSUNDEEP
google-sheets
Suphi
Suphi

Reputation: 11

How to avoid multi-user overwriting on Google Sheet

I have a Google sheet making some calculations and multiple users will use this calculator.

Eventually, they will be updating the same field to get a result and I couldn't find a safe way to avoid overwriting.

Do you guys have any idea?

Upvotes: 1

Views: 1310

Answers (1)

doubleunary
doubleunary

Reputation: 19155

In Google Sheets, all changes the users make are saved automatically and right away, and users see each other's changes in real time. There are a couple of ways to avoid overlapping edits:

  1. Create a separate copy of the Google Sheet for every user. The easiest way to do this is to give them a link to the spreadsheet that ends in /copy instead of the usual /edit.

  2. Redesign the spreadsheet so that all entry cells and the result cell are in the same row. Instruct the users to enter their input each in a row of their own. Use an array formula to automatically calculate the result for every row that gets inserted.

  3. Rewrite the calculator user interface as a web app. This requires the use of HTML and JavaScript in the UI, but the calculations can still be done with array formulas in a Google Sheet. See the Web App Demo answer for more information and sample code.

Upvotes: 1

Related Questions