Using templating for “private” input gathering
You can use the templating workflow to collect assumptions from contributors without them seeing anything but the worksheet shared with them:
- Create various worksheets (with different structures) with different assumptions you want to gather from different contributors.
- Invite contributors as described in the section above.
- Have the formulae in your calculation worksheet linked to the worksheets filled by the contributors.
Sharing only individual worksheets with collaborators
You can assign permissions to worksheets to exclude them from view of certain collaborators when you share the project with them. Click on Access in the worksheet menu.