Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Using Reports to Isolate User Access
I need to manage information pertaining to a client (single row per client) that contains three different types of information used by three different users. The sheet has formula that I want to continue down the sheet automatically. Because we are using webforms to register new client information, every time a user goes into the sheet, it creates ten new rows, and then webform entries start many rows down the sheet, and the formula does not! a big pain.
I want to limit each collaborator to view and edit the information relevant to them only from within reports that I share with them - is it possible that they can be "viewer only" on the sheet, but "editor" on the report? Or is it possible to not be shared to the sheet at all, but still able to comment on the report?