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:
Hi,
I got 5 sales reps that all log their new customer in rows on a master sheet. Each row has an assign to column for each sales rep. How could I share this sheet to each one of the sales rep so that they can only see their customers and not have access to the ones their peers are logging in?
Hi Junio,
Unfortunately, it's not possible to "isolate" the information in the sheet so that .no one else can access it.
Do you want/need to make it impossible for the sales reps to see each other's information?
If yes, I would suggest setting up one sheet per sales rep and then collect everything for you and others in a report instead.
The second option could be to use the premium add-on called Dynamic View.
More info. https://www.smartsheet.com/product/dynamic-view
Would that work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
This is basic functionality not a premium add-on. This is one crazy business model in my opinion.
@Mike L. : Your comment made me smile :D Nevertheless, I agree with you 100%.
New to smartsheet, and quite surprised that this does not exist as a basic feature.
This is an important feature when working with teams from multiple companies. This is also the reason I've eventually abandoned other PM applications. Smartsheet should make this a standard feature.
I've used different low code/no code toolsets. Smartsheet does a decent job in this arena, however, the security model has a gaping hole in it.
Each row should have two built in columns where an admin or developer can compute the values.
Either of the two fields will contain a combination of one or more User Names (email), Groups, or Roles.
The software would automatically show / hide rows based on the user accessing them. If the user is not a member of either the reader / editor fields they can't see the row. This is standard issue for any data management system and easily programmed into the core library of the underlying program.
If you need help coding this I'm available 😁
Hi all, Hopefully this is a simple solution that I'm just missing, but if I have a report view of a main sheet, is there a way to click on a particular row in the report and have it link to the full details available in the parent sheet? I want to be able to provide folks a simple view of everything, but reports fail for…
Hi Community, We encountered an unexpected issue with a Dynamic View today. An admin who had previously been added to the Dynamic View was found to be missing from the Admin list. We are confident that the admin was not manually removed or edited by our team. We noticed the issue at approximately 9:30 AM on Monday (UTC+8),…
Hi, This morning (UTC+8) we can not edit the data shuttle. When I go into the edit page of data shuttle it says I need to ask for access approval to continue. But I am the manager of the data shuttle. And from the sharing setting page, I can confirm that I am still in the manager list. Is this an internal server problem?…