Sharing only certain data for edit on sheet.

Junio`

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?

Find more posts tagged with

Sales

Finance

Support

Comments

Andrée Starå

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

Mike L.

This is basic functionality not a premium add-on. This is one crazy business model in my opinion.

Thimmo Borger

@Mike L. : Your comment made me smile :D Nevertheless, I agree with you 100%.

kunal kumar

New to smartsheet, and quite surprised that this does not exist as a basic feature.

David Tooke

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.

Steve Rieger

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.

List of who can Read the row
List of who can Edit the row

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 😁

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…