Is it possible to prevent the deletion of rows in a sheet? Specifically, in cases where a user legitimately requires editor permission to the underlying sheet and where the row cannot be locked (as continued editting of the row is required.)
If not, what are some strategies for recovering a row that has been inadvertently deleted? E.g. is it possible/reasonable to automatically copy the row to a side-sheet prior to the row being deleted, and then restoring that row to the original sheet?