Allowing people to access reports without having access to the main sheet

Richard D. Vogt
Richard D. Vogt ✭✭✭
edited 12/09/19 in Smartsheet Basics

Is there any way that I can share reports with various people and give them the ability to edit information through their report without sharing the main sheet with them? In other words, giving them write access through the report, but not allowing them to see, open, write on, or access the main sheet in any way? They don't even need to know the main data sheet exists. This would be like Write Only, No View access, and would allow me to put other sensative information on the main sheet. It would also allow me to control who accessed certain areas of the main data sheet while still being able to write on it. As I currently understand it, data coming in to a report cannot be seen by the user unless they have been given shared access to the sheet the data is coming from.