"Protect sheets and ranges" options are missing from .gsheet created within Dropbox

Question

My team uses a shared Dropbox, and we'd like to be able to collaborate on a google sheet in real-time. I made a google sheet following the instructions here: https://help.dropbox.com/installs-integrations/third-party/create-google-docs

And it works, mostly - except, a few features are missing that are very important, particularly, the ability to protect/lock previous entries. This is essential to ensure we keep accurate records that are not mistakenly over-written over time.

Anyone else have a similar issue or know of a solution?

Jay · Answer

Hi @ckfaber, we appreciate the feedback on this matter. If you wish, you can 
suggest this change for others to vote on, so the dev team can look into this in future.

ckfaber · Answer

Hi Walter,

Thanks for the link, but unfortunately that is not going to be a workable solution for us - we need data entered at the completion of a study to be immutable, and only allow new rows to be entered. Chasing previous versions will cause problems if one day, someone is entering new data but accidentally also deletes or changes previous data. Restoring to the old version will preserve the old data but lose the new data. The option to protect sheets/ranges is available by default in Google Sheets normally, but for some reason, is lost when integrated with Dropbox.

Walter · Answer

Hey @ckfaber, thanks for using Dropbox and posting on our Community!

Since you're storing those files in your Dropbox account, the edits you apply to the file will be saved in our servers.

This means that you'll be able to restore a previous version, if needed, as outlined here.

I hope this helps a tad!