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, pleaseVisit the Current Forums.
Understanding Workspaces
Comments
-
Jaye Casciano ✭✭✭✭✭✭
Someone please correct me if I'm wrong, but I don't believe you can. Would love to know if I'm wrong as I'd use that functionality.
-
Tim Meeks ✭✭✭✭✭✭
Jaye is correct.
Not at this time. . that's the purpose of the workspace. Any sheet placed in it takes on the sharing permissions of the workspace. Also, your idea may work if there was only 1 sheet the workspace. But if there were multiple sheets, there would have to be an indicator on when to follow the workspace permissions and when to override.
However, there was a survey a couple of months ago asking about workspace sharing options. And there is a list on the SS Product Road map of this feature. But not sure when it will be out or exactly when will be changed.
//www.santa-greenland.com/product-roadmap
Maybe Travis and team can comment on the features and ETA.
Tim
-
Jaye Casciano ✭✭✭✭✭✭
Thanks Tim, appreciate you much-expanded answer
-
Thank you Jaye & Tim. May I expand on my question? For a sheet in a workspace, can you increase the sharing beyond the workspace limitations?
For instance, I have a Marketing workspace that includes the 5 members of the Marketing team but for a particular sheet in there I need to include the Executive Assistant who is part of the Executive Team, not the Marketing team, can that be done?
-
Tim Meeks ✭✭✭✭✭✭
Pamela & Jaye,
You are welcome.
To answer the question, No. As of right now, you can't add the Exec Asst to only one of the sheets in the workspace. If you do, the EA will get access to ALL the sheets in the work space. To do what you need done, you would need to either move that one sheet out of the Workspace and back into the Sheets folder or into a NEW workspace that includes the EA.
Think of this way.... When I used to go roller skating ( a long time ago), there would be an "ALL SKATE" time for beginners and expert skaters to share the floor. A workspace is like an ALL SKATE. Everybody gets the same access to the floor. Sharing permissions occur at the workspace level and are the same for any sheet placed in the workspace.
Hope the analogy helps.
read below for more detail:http://help.smartsheet.com/customer/en/portal/articles/522067-workspace-sharing
Sharing a Workspace with a collaborator will grant them access to all sheets, reports and templates it contains. The collaborator will have the same sharing permission level on all items in the Workspace. Items in a workspace can't be shared individually, but you canmove the sheet out of the workspace,and then share it to the appropriate collaborators.Tim
-
Travis Employee
Just to chime in here... As Tim has stated, at the moment its not possible to have individual sharing permissions on sheets located in workspaces. If you want to have individual sharing permissions for sheet, I would recommend using folders to organize your sheets instead.
We are working an an enhancement for workspace sharing which should be releasedearly2016.
-
Jaye Casciano ✭✭✭✭✭✭
我第二个Stefan的反应——你可以选择克雷亚te a workspace specifically for your Executive(s) and include a report in it for him/her to review, OR you could set up a report to send directly to the Exec via pdf/spreadsheet/e-mail. For example, I have a worksheet that acts as a master calendar for all activities my Marketing Specialists are involved in. I've set up a report to send to my leader, bi-weekly, to give a 30 day outlook of these activities (I could also choose to manually send it whenever she asks). Hopefully this helps!
-
Is this correct
We can add a folder to the workspace,
Within the folder add several sheets
We can share a sheet with a user and they can only see that sheet and not all the folders ?
But we can not add several folders to Workspace and only share one folder
UGG
Categories
=MAX([Modified]:[Modified]) + \"//www.santa-greenland.com/community/discussion/3737/\"<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107030,"type":"question","name":"How to subtract percentages?","excerpt":"I created a new column % Not complete and am trying to add a formula to have =100%-[%Complete]@row. Answer #UNPARSEABLE I have also tried =100-%Complete]@row. Answer: This will populate an answer, however I cannot adjust the formatting from % to number Example: %Complete = 13% Correct answer should display 87% Second…","snippet":"I created a new column % Not complete and am trying to add a formula to have =100%-[%Complete]@row. Answer #UNPARSEABLE I have also tried =100-%Complete]@row. Answer: This will…","categoryID":322,"dateInserted":"2023-06-28T15:56:57+00:00","dateUpdated":"2023-06-28T16:22:44+00:00","dateLastComment":"2023-06-28T16:35:48+00:00","insertUserID":150369,"insertUser":{"userID":150369,"name":"v.winters","url":"https:\/\/community.smartsheet.com\/profile\/v.winters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p_DnqRu23us!e98n5_-JJOs!fH1r3mTuHpU","dateLastActive":"2023-06-28T16:34:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150369,"lastUserID":150369,"lastUser":{"userID":150369,"name":"v.winters","url":"https:\/\/community.smartsheet.com\/profile\/v.winters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p_DnqRu23us!e98n5_-JJOs!fH1r3mTuHpU","dateLastActive":"2023-06-28T16:34:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3375939165,"url":"https:\/\/community.smartsheet.com\/discussion\/107030\/how-to-subtract-percentages","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107030\/how-to-subtract-percentages","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107030,"commentID":382885,"name":"Re: How to subtract percentages?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382885#Comment_382885","dateInserted":"2023-06-28T16:35:48+00:00","insertUserID":150369,"insertUser":{"userID":150369,"name":"v.winters","url":"https:\/\/community.smartsheet.com\/profile\/v.winters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p_DnqRu23us!e98n5_-JJOs!fH1r3mTuHpU","dateLastActive":"2023-06-28T16:34:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T16:35:51+00:00","dateAnswered":"2023-06-28T16:31:26+00:00","acceptedAnswers":[{"commentID":382883,"body":"