Column Editing Restrictions

ambrooks

Hello,

I have approximately 50 users that routinely review and update the data in columns in my SmartSheet. However, for 3 columns in my sheet, I need to restrict 47 of my 50 members from being able to update the data in those specific columns. The rest of the sheet can be updated by any user. Locking the column allows only admins to update, and I do not want to make any users an admin, so is there another way to "lock" the column for a portion of my users while keeping it "unlocked" to the rest?

Thanks!

Mike Wilday

There is no foolproof way to do this. You could hide the columns in the main sheet and serve reports to the various individuals, gathering the 3 columns to those who have access to their report. 

MattH

Consider using automated update requests.