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
Check out the Formula Handbook template!