We often have the case of two people overwriting each other's changes by writing on the same cell at the same time.Is there a way to make it so that cells can't be written by more than one person at a time? For instance, by having them locked for other editors when they are selected by a user.
Preventing concurrent editing of a cell in Google Spreadsheet?
google spreadsheets