I am evaluating a number of real-time collaboration tools for our company. What we need is a spreadsheet that can be shared with a number of collaborators, and can be worked on without the collaborators seeing eachother and only having access to a specifik column as they are competitors. This would minimize our work as organizers from having to cut/paste from individual spreadsheets to the master spreadsheet (as we do now) and instead streamline work so that the different collaborators do all the work up untill the moment we close the door for sharing for each group, and take the master spreadsheet for further sharing to external partners from our end as organizers.

I have seen that there is an option to limit what to share to a specifik section in a spredsheet, but it seems to be read-only. Is there a way to have the functionality I am describing above?

Thnks

Samer