Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Locking Cells/Columns in a Report
Hi Smartsheet -
I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we noticed you cannot do that in a report. Can you allow the locking feature in reports?
Comments
-
Ray,
See this article on locking rows/columns:
https://help.smartsheet.com/articles/522077-locking-unlocking-columns-and-rows
The locking needs to be done on the sheet, not the report.
If the user is an Admin on the underlying sheet, they will ignore the lock.
Hope that helps.
Craig
-
Ray,
What J. Craig Williams says is true. Make sure that the users on the original sheet are just editors, not admins. And then any lock you set on rows or columns in the original sheet will flow through to the reports.
