Is there a way by which users can only view their rows instead of having rights to view other users

Jimmy

Hi All,

Is there a way were a user can just view and edit his/her rows and he/she shall not be able to view other user rows.

Example:

Attached screenshot.I have two contact David and Charles.

Now, If David wish to update his data on the sheet he would not be able to view Charles rows vice versa.

Find more posts tagged with

Sheets

Comments

Andrée Starå

Hi Jimmy,

There are two ways as I see it.

They update the information thru Update Requests
Users have personal sheets, and then everything is collected on a report for you (or someone else) to see.

Would that work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Jimmy

Hi Andree,

If I choose the 1 option you mentioned;every time I have to send they update request email is that something I have to do? or will they be able to view there rows and update them.

Can you please show an example.

2 option can you please show with an example how to create a report and share that report to the user so that every time they make any changes on the report it get auto update on the sheet.

Appreciate your support

Andrée Starå

Happy to help!

Answers to your questions are below.

If I choose the 1 option you mentioned;every time I have to send they update request email is that something I have to do? or will they be able to view there rows and update them.

It can be automated to send at specific intervals or when something changes or happens in the sheet.

Can you please show an example.

I'll get back to you with examples later today.

2 option can you please show with an example how to create a report and share that report to the user so that every time they make any changes on the report it get auto update on the sheet.

The report will show the sheets information, meaning that if you change anything in the report, it will change at the same time in the sheet.

I'll get back to you with examples later today.

Appreciate your support

Best,

Andrée

Jimmy

Appreciate if you could help me with an example for 2 option that shows how to create a report from the sheet and how if anything changes on the report it should change the sheet at the same time.

Andrée Starå

Hi Jimmy,

Do you still need/want an example?

Best,

Andrée

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…