Limiting editable access to certain users

Hello there everyone interested!

We're looking to share sheets to various departments here however we don't want all cells to be able to be filled in (or changed) by all users.

Is there a way that we can restrict editable fields to certain user accounts so user A can only edit columns 1-3 and user B can only edit columns 4-5 etc please?

Glad of all tips. Many thanks.

Find more posts tagged with

Manufacturing

Sheets

Sharing and Collaboration

Contacts

IT & Operations

Groups and Group Management

Account and User Management

Comments

Richard Rymill SBP

Trevor

Not without some challenging design work to achieve it, but the easy answer is "To give work to your colleagues" using Reports as To Do Lists, so they only see and edit the columns you want them to see.

They will need to have access to the underlying sheet, but if you make it easy for colleagues to use this system and explain WHY, it becomes very simple and a popular one.

You could also remind users that if they do change data where they should not... it is recorded in the history! of the cell.

Hope that helps?

RichardR

Mike Wilday

Here is a helpful article on creating reports.

https://help.smartsheet.com/articles/522214-creating-reports

TrevorM

Hello Richard,

Not entirely the response I was wanting but very helpful all the same!

Thanks very much - will try this route next then. Seems straight forward enough.

Kind regards,

Trevor

TrevorM

Thanks Mike,

I guess that will come in handy too.

I haven't used the reporting function before now.

Many thanks,

Trevor

Richard Rymill SBP

Trevor

a quick an easy way to set up all your relevant Reports for each criteria is to set one up and test it. Once you are happy with it, Save as new and eg change the worker name from Justin to Jodie and then so on and with a simple change to the criteria you quickly have as many individual to do lists as you need.

If you want to make it easy to find these ( and all your important sheets) just list them like a library in your dashboard using live links.

Another thought? Make sure your main sheet has Data triggers in there, so when work passes from one to another, Like a Relay Race Baton, the Reports automatically update in real time based on those data Triggers. eg if part one is complete, start Part two etc.

Then you have an automatic workflow that flows your processes.

Hope that helps and lots more where that cam from if you get stuck?

RichardR

SBP.

Sign in to join the conversation!

Quick Links

Trending discussions

Mr
hi would like to create a simple patient tracking system for our small clinic where i can record the time & duration a patient appeared in our establishment. Using a central sheet where it records all the data to be accessible by the admin. There will also be Four (4) forms to be accessible by the three department. Concept…
Forms
On the App - "In Smartsheet forms, is there a way to capture or upload an image directly into a specific column cell (per row) without using the Attachments field? I need each section of the form to have its own dedicated image, not just general attachments for the row."
Smartsheet Mobilizer Kit2/Best Practices
Hi - I am launching Smartsheet sessions at my organization for the next 3 months. The SS Mobilizer Kit2 Workspace I saved a few years back, the files are not loading. Is there a new resource kit? Also, I am writing up some best practices for our users: Examples: Names, separate first and last name into two columns. Email…