Lock cells that contain formulas
Hello,
Is there a way to lock cells that contain formulas?
I ask because although there is a way to lock columns/rows, I've found that (all parties w/Admin privileges) you can accidentally click on a cell and change the formula.
Cheers. 😀
Best Answer
-
Yes, sheet Admins can alter locked rows and columns. However, if your formula applies to the entire column, you can convert it to a "column formula," which requires an Admin user to right click on the formula, then select Edit Column Formula or Convert to Cell Formula, before they'd be able to change or erase the formula.
More info here:
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
Yes, sheet Admins can alter locked rows and columns. However, if your formula applies to the entire column, you can convert it to a "column formula," which requires an Admin user to right click on the formula, then select Edit Column Formula or Convert to Cell Formula, before they'd be able to change or erase the formula.
More info here:
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you, @Jeff Reisman
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!