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.

Export List of People a Sheet is Shared With?

Jess Merritt
edited 12/09/19 inArchived 2017 Posts

Is there a way to export a list from a sheet that shows the user's security level? And if so, can this list be imported to a new sheet so that each team member does not have to be added manually to the new one?

This is not necessarily for a template that is used repeatedly. It is a group of about 150 people, various combinations are common for most projects that I track. This would save a huge amount of time if available. As it is now, I have to take screen shots, which seems very inefficient.

Even if it is not possible to apply the shared list to a new sheet, just having an Excel copy would prevent the need to take a screen shot of every five team members and would save time.

Comments

This discussion has been closed.
Hi Yuval,<\/strong> <\/p>

You can try this formula for your condition- <\/p>

=IF(AND([Materials in Rigotec\/Talad]@row = true, [Materials in CR]@row = true, [HC in Place]@row = true, [QA\/QC done before install]@row = true), \"Green\", IF(AND([Materials in Rigotec\/Talad]@row = false, [Materials in CR]@row = false, [HC in Place]@row = false, [QA\/QC done before install]@row = false), \"//www.santa-greenland.com/community/discussion/7729/\", IF(OR([Materials in Rigotec\/Talad]@row = false, [Materials in CR]@row = false, [HC in Place]@row = false, [QA\/QC done before install]@row = false), \"Red\"))) <\/p>

Hope this will work for you <\/p>"},{"commentID":389689,"body":"

Cool, many thanks Kaveri, working as watch, just copy and paste, perfect<\/p>

Yuval<\/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":108650,"type":"question","name":"Restrict Visibility to team members assigned to your Workspace sheet","excerpt":"I am trying to find out a way where I can restrict the team I assign a task to, that when they login into Smartsheet, they are only able to see the tasks they are assigned to, however, I can find a way in the business plan. In addition, I watched a webinar where I could request updates in the emails, where the person would…","snippet":"I am trying to find out a way where I can restrict the team I assign a task to, that when they login into Smartsheet, they are only able to see the tasks they are assigned to,…","categoryID":343,"dateInserted":"2023-08-08T06:37:40+00:00","dateUpdated":null,"dateLastComment":"2023-08-09T09:05:59+00:00","insertUserID":164639,"insertUser":{"userID":164639,"name":"Nandafc","url":"https:\/\/community.smartsheet.com\/profile\/Nandafc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-09T09:17:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-09T10:35:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":43,"score":null,"hot":3383052219,"url":"https:\/\/community.smartsheet.com\/discussion\/108650\/restrict-visibility-to-team-members-assigned-to-your-workspace-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108650\/restrict-visibility-to-team-members-assigned-to-your-workspace-sheet","format":"Rich","lastPost":{"discussionID":108650,"commentID":389699,"name":"Re: Restrict Visibility to team members assigned to your Workspace sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389699#Comment_389699","dateInserted":"2023-08-09T09:05:59+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-09T10:35:03+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-08T23:54:12+00:00","dateAnswered":"2023-08-08T12:53:02+00:00","acceptedAnswers":[{"commentID":389453,"body":"

They would have to still be shared to the sheet as at least editor as well as to the report as editor to be able to make updates through a report.<\/p>

This sounds like the perfect use case for the premium add-on Dynamic view.<\/p>


<\/p>

In the meantime, here is some more information on Update Requests (which they do not need access to the sheet to be able to fill out).<\/p>

\n \n https:\/\/help.smartsheet.com\/learning-track\/smartsheet-intermediate\/update-requests\n <\/a>\n<\/div>


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":108658,"type":"question","name":"Is it possible to restrict certain information within a sheet based on users?","excerpt":"I have admin access to a sheet that was created internally. There are other users that have access as well but I'd like to restrict certain information within the sheet to particular users. Is it possible to create a condition that will restrict certain information?","snippet":"I have admin access to a sheet that was created internally. There are other users that have access as well but I'd like to restrict certain information within the sheet to…","categoryID":321,"dateInserted":"2023-08-08T13:36:00+00:00","dateUpdated":null,"dateLastComment":"2023-08-08T19:58:41+00:00","insertUserID":164732,"insertUser":{"userID":164732,"name":"Kee2743","title":"Retail Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Kee2743","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTteWMneYat4gsscR1ImM4CERDOCaRXFYfw4DmN88V6cf=s96-c","dateLastActive":"2023-08-08T19:59:19+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-09T00:57:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":50,"score":null,"hot":3383031281,"url":"https:\/\/community.smartsheet.com\/discussion\/108658\/is-it-possible-to-restrict-certain-information-within-a-sheet-based-on-users","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108658\/is-it-possible-to-restrict-certain-information-within-a-sheet-based-on-users","format":"Rich","tagIDs":[437],"lastPost":{"discussionID":108658,"commentID":389599,"name":"Re: Is it possible to restrict certain information within a sheet based on users?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389599#Comment_389599","dateInserted":"2023-08-08T19:58:41+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-09T00:57:43+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-08T17:50:19+00:00","dateAnswered":"2023-08-08T15:21:25+00:00","acceptedAnswers":[{"commentID":389524,"body":"

Hi @Kee2743<\/a> <\/p>

I hope you're well and safe!<\/p>

If it's ok for the users to be able to access the information, but you want to hide it to simplify or make it harder to see, you could use a Report.<\/p>

Would that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"},{"commentID":389539,"body":"

You could use a report, but that means the users will still need to be shared to the underlying report with at least editor access.<\/p>


<\/p>

Do you have access to Dynamic View or WorkApps?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]}],"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":[]}">

Trending Posts