Lock cells that contain formulas

Kaye T.

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. 😀

Jeff Reisman

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:

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Jeff Reisman

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:

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Kaye T.

Thank you, @Jeff Reisman