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.

Sharing and Limiting Report Information

Roger Varner
edited 12/09/19 in Archived 2017 Posts

Scenerio - I have a MASTER sheet that I am using to communicate with different contractors via individualized reports.  The contractors are required to make updates to several fields.  Once I assign a line or job to a contractor - it shows up on their  individual report.  Each line/job has contract specific details in the form of an attachment.  Is there a way to limit lines to a specific contractor in the Master sheet.  


The attachment has rate details that shouldnt be viewed by other contractors.  I would like to keep all contractors on one Master sheet.  Any suggestions?


Thank you






  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    There is not any row/column/cell level permssions available.

    If they need to modify the same sheet, then your options are limited.


    Here's one:


    Create a Report for each contractor.

    Publish the Report and provide each contractor the link to their Report.

    They do not need to be shared to the Sheet to see the data.

    But ... it isn't editable.

    They will have access to the row attachments though.


    To get them to securely edit certain parts of the sheet, you could try Update Requests, but those are on-time use and do not work in every work-flow.




This discussion has been closed.