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'm currently creating a sheet with numerous tasks that will be 'Assigned To' other Users. I would like to have the other users only see and edit their tasks, and not have any access to the other Users' tasks. Is this possible? Thank you, Lloyd
Yes, create a report for the users. In the report builder you under "Who" you can set the field "Assigned To" = a specific user name. Alternatively you can set "Assigned To" = Current user. This will allow you to reuse the same report for each user. Each user will be able to see only their tasks.
Your tasks are entered into the smartsheet grid. Your users will work from a smartsheet report seeing only what's assigned to them.
disclaimer: I'm relatively new to smartsheets but this is what I'm doing.
Hi Lloyd and Mike,
A cautious note.
The user must be shared to the sheet(s) to be able to see the sheets information on the report. This means that the user can potentially open the sheet(s) and see other information. The viewers of the report can only see what is shared to them.
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
Thank you Mike.
Hi Andrée,
Thanks for your response. Allowing other users to see the source sheet creates a problem in this scenario. Will keep looking for a solution.
Thanks,
Lloyd
You could manage each user's tasks in a separate sheet and then create a report that would allow you to see all users' tasks in one report. Would that work?
Hi Mike, thanks for your response. I could see how your solution could work, but I'm designing a full project plan ("Primary Sheet") with related / dependent tasks and then I would assign to different people. I was hoping that: a) the user only sees their tasks, and b) the users' updates flow into the Primary Sheet. Thanks, Lloyd
Yeah, that makes sense. This is one item in the application that is a little frustrating. There are a lot of reasons why giving report users access to the original sheet doesn't make sense. You don't want users to see other users' data.
A couple of workarounds that other users have implemented is burying the sheet deep within a nested subset of folders with odd naming to prevent users from stumbling onto the original dataset. Doing this would involve also providing access to the original sheet but not notifying them that they have it. I haven't personally tested this functionality, but I imagine it could help prohibit access.
I've also seen use-cases where a default filter is put on a sheet so when it is loaded it automatically filters data by the Current User. That way if someone does stumble on the original sheet the filter is another safety mechanism.
Not sure if any of those solutions help, but maybe so. Best of luck!
Thanks very much for the suggested options!
You're welcome. Hopefully, some of them will help you find a workable solution for Smartsheets.
Happy to help!
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
I am extremely frustrated and disappointed with my current Smartsheet experience. I have paid for a Pro subscription, I am the owner and administrator of my account and sheets, and I have confirmed I am logged into the correct account. Despite this, Smartsheet is not recognizing my Pro subscription, and I am unable to…
