Locking cells in sheet



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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!