Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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?
Couldnt you just add those five people to the sheet sharing of the weekly sheet?
Yes, but when I "Save as New" for the next week they have to be readded since they arent smartsheet users
Laura,
You could create a new (second) workspace with the 12 shares (7 internal, 5 external).
The weekly sheet would reside there.
Craig
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.
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
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.
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!
Do those 5 people need to edit the sheet or they just need it read only?
Ricki - They're Read Only
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
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.
