I work for United Way and we are currently incharge of managing our communities homeless "By Name Lists". In a nutshell, these are lists of current homeless people in our community, and is a way for agencies that provide housing to work together in helping people get housed.
Also, because we're a non-profit, we only have the funds to do the "Individual" plan.
I am the only one with admin rights, and we have everyone set-up as editors.
We have the sheets set-up with locked columns, because we need to make sure the data is not tampered with, but allow people to leave comments on the progress of the homeless people they are working with.
Sometimes the info in the cells needs to change though, such as if an agency finds out an updated phone number for one of the homeless people. I was hoping we could use the Update Request for situations like this, but because the columns are locked, we can't edit them from the email notification.
To sum up my question, what's the best way where we can share a sheet, but not allow the people it's shared to, to edit it, but still let us know when updates need to take place?
