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.

Sheet Sharing

Laura
Laura โœญโœญโœญโœญโœญโœญ
edited 12/09/19 in Archived 2017 Posts

I have a sheet that I "save as new" weekly in one workspace. The workspace has 7 people but the sheet I share weekly has 5 additional people who do not need to be shared to the entire workspace but do need to see that sheet weekly. Any advice on how I can keep these people saved to the sheet without having to add them each week?ย 

Comments

  • ricki
    ricki โœญโœญโœญโœญโœญโœญ
    edited 03/16/17

    Couldnt you just add those five people to the sheet sharing of the weekly sheet?

  • Laura
    Laura โœญโœญโœญโœญโœญโœญ
    edited 03/16/17

    Yes, but when I "Save as New" for the next week they have to be readded since they arent smartsheet usersย 

  • J. Craig Williams
    J. Craig Williams โœญโœญโœญโœญโœญโœญ

    Laura,

    ย 

    You could create a new (second) workspace with the 12 shares (7 internal, 5 external).

    The weekly sheet would reside there.

    ย 

    Craig

    ย 

    ย 

  • Laura
    Laura โœญโœญโœญโœญโœญโœญ

    Craig -ย 

    ย 

    I thought about doing that but it would be just a workspace for that one sheet. The 5 external people dont apply to anything else besides that one sheet.ย 

  • ricki
    ricki โœญโœญโœญโœญโœญโœญ

    You can add them to your address book. You would still need to add them each week but they should be easily available on your list

  • J. Craig Williams
    J. Craig Williams โœญโœญโœญโœญโœญโœญ

    Laura,

    ย 

    I thought so. You just need to weigh the cost of sharing the new sheet vs your internal users having to go to a different workspace.

    ย 

    Craig

  • Laura
    Laura โœญโœญโœญโœญโœญโœญ

    Ricki - They're in my address book. I was just trying to find a solution to not having to add them weekly.ย 

    ย 

    Craig - I've decided to just export the sheet to PDF weekly and have one sheet. That solves some little inconviences I facing with the notifications, etc.ย 

    ย 

    Thanks yall!ย 

  • ricki
    ricki โœญโœญโœญโœญโœญโœญ

    Do those 5 people need to edit the sheet or they just need it read only?

  • Laura
    Laura โœญโœญโœญโœญโœญโœญ

    Ricki - They're Read Only

  • ricki
    ricki โœญโœญโœญโœญโœญโœญ

    I wonder then if there is something you could do with a report rather than using the sheets

    ย 

    for example you can have a master sheet with all of the weeks items and add a column for week and then have the report filter by the max week or something and then just grant access to the report once

  • J. Craig Williams
    J. Craig Williams โœญโœญโœญโœญโœญโœญ
    edited 03/16/17

    ricki,

    ย 

    Reports require access to the sheet.ย 

    But if the Report was published, then anyone with the link will be able to access the sheet (read only).ย 

    If security is not an issue, then this may be a possibility.

    ย 

    Craig

This discussion has been closed.