Using templating for “private” unstructured 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.
Setting permissions at worksheet level