Locking cells in sheet
Hello,
I am trying to determine if there is a way to lock the formulas I have placed in my sheet so that the users cannot override them to hard key in numbers. The formulas have been entered into all of the necessary cells but as it stands, users can simply clear them out to enter the amounts in their own way. We have these formulas as a way to verify accuracy and it is important from an operational standpoint that these are universally applied across all projects, regardless of the project manager.
Does anyone have any recommendations for how to do this? If it is not possible, does anyone have an alternative suggestion they could make?
Answers
-
@afantozzi are they all in the same column? If so, you can lock the column so only Admins can edit it. You can also lock entire rows. Otherwise, there's no way to "lock" individual cells.
-
@Ryan Sides If you look at a screenshot of the template below, the green, orange, grey, and brown columns have formulas. The way the sheet is intended to work, once the appropriate sub's waiver arrives, it is attached to their row in the sheet and the PC Approval column is dated, advancing the workflow to the next approver and so on.
-
@afantozzi Makes sense. So right click on the green through brown column headers and select "Lock Column". Then, make sure the users shared the sheet are Editors, not admins.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!