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.
Creating a Workspace with already shared sheets
Hello everyone,
So I would like to know wether I need to share a workspace that I have created with sheets that haave already been shared.
I have shared 2 x Inventory lists with the team (we are a small team so that was simple) however now that I have over 20sheets in my list I am creating workspaces to better collate similar and same type sheets.
I have added these two sheets into a Workspace 'Inventory Management' - both sheets have the same sharing properties to each team member. My question is do i now have to share the Workspace to continue their access, or will they still be abel to view the live and updated version of these sheets?
If I do share the workspace as a workspace with the 2 sheets 'inside' will they then double up on the sheets? ie, shared as a Sheet AND as a Workspace.
Thanks
Comments
-
No, you do not have to share the workspace in order to retain their sheet sharing permissions. When you move the sheets into the newly created workspaces, you'll see . Which means that there is a workspace containing individually shared sheets.
I would, however, share the Workspace with them for efficiency on creating future sheets, as they will have access to the sheets created in the workspace at the workspace permission level you give them. If you don't share the workspace with them, they won't see the new sheets you create unless you expressly share the sheet with them.
Sharing the workspace will not duplicate any sheets.
http://help.smartsheet.com/customer/en/portal/articles/522067-workspace-sharing
-
Amye ✭Thanks Greg, that makes total sense.
Cheers
Categories
=IF(COUNT(ANCESTORS([Task Name]@row))>1, INDEX(ANCESTORS([Task Name]@row), 2))<\/p>
<\/p>
I've never needed the first column reference before, but maybe it is just being picky for some reason.<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":108606,"type":"question","name":"How do I calculate the count of project days within a quarter given the project start and end dates?","excerpt":"I have a sheet with all of the current projects, each project is along one row. I'm looking to create a column formula that is a count of project days if the project falls within a specific quarter. I've tried to type this out but cannot get the syntax right in smartsheets. I was thinking it would be one IFS statement with…","snippet":"I have a sheet with all of the current projects, each project is along one row. I'm looking to create a column formula that is a count of project days if the project falls within…","categoryID":322,"dateInserted":"2023-08-07T14:45:21+00:00","dateUpdated":null,"dateLastComment":"2023-08-07T15:41:06+00:00","insertUserID":164666,"insertUser":{"userID":164666,"name":"mlj","url":"https:\/\/community.smartsheet.com\/profile\/mlj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-07T20:01:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-07T21:40:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":null,"hot":3382842987,"url":"https:\/\/community.smartsheet.com\/discussion\/108606\/how-do-i-calculate-the-count-of-project-days-within-a-quarter-given-the-project-start-and-end-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108606\/how-do-i-calculate-the-count-of-project-days-within-a-quarter-given-the-project-start-and-end-dates","format":"Rich","lastPost":{"discussionID":108606,"commentID":389244,"name":"Re: How do I calculate the count of project days within a quarter given the project start and end dates?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389244#Comment_389244","dateInserted":"2023-08-07T15:41:06+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-07T21:40:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-07T20:01:21+00:00","dateAnswered":"2023-08-07T15:41:06+00:00","acceptedAnswers":[{"commentID":389244,"body":"
There is no IFS function in Smartsheet. Try this instead.<\/p>
<\/p>
=MAX(NETWORKDAYS(MAX([Start Date]@row, DATE(2023, 01, 01)), MIN([End Date]@row, DATE(2023, 03, 31))), 0)<\/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":108604,"type":"question","name":"Report\/Dashboard Question","excerpt":"Hi all, I am building reports and a dashboard for the support tickets my team receives. I want to create a report and chart to show the number of tickets our clients have submitted so far this year. Since we have well over a 100 clients, there are some clients that have only submitted 1 ticket this year. I'm trying to…","snippet":"Hi all, I am building reports and a dashboard for the support tickets my team receives. I want to create a report and chart to show the number of tickets our clients have…","categoryID":322,"dateInserted":"2023-08-07T13:15:56+00:00","dateUpdated":null,"dateLastComment":"2023-08-07T15:58:04+00:00","insertUserID":158227,"insertUser":{"userID":158227,"name":"BristolCVN","url":"https:\/\/community.smartsheet.com\/profile\/BristolCVN","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-07T15:58:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-07T21:40:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":34,"score":null,"hot":3382839840,"url":"https:\/\/community.smartsheet.com\/discussion\/108604\/report-dashboard-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108604\/report-dashboard-question","format":"Rich","tagIDs":[265,292],"lastPost":{"discussionID":108604,"commentID":389261,"name":"Re: Report\/Dashboard Question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389261#Comment_389261","dateInserted":"2023-08-07T15:58:04+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-07T21:40:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-07T15:51:58+00:00","dateAnswered":"2023-08-07T14:26:43+00:00","acceptedAnswers":[{"commentID":389214,"body":"
You will need a helper column on the source sheet with a formula (checking a box in the below) to show which rows should not be included.<\/p>
=IF(COUNTIFS(Client:Client, @cell = Client@row) = 1, 1)<\/p>
<\/p>
The above should check the box on all rows where there is only a single entry for that client. You can then include a filter in your report to show rows where that box is not checked.<\/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":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">