Help locking a column

I locked a column (im the admin). But somehow another user that has admin permissions as well was able to change a cell within the locked column. It erased the formula.

Am I missing something? How do I make it to where I'm the only one that can change the cells in that locked column.

Thanks in advance.

Find more posts tagged with

Sheets

Comments

VAcePro

Admin permission is permitted to update locked cells. Lowered the other users permission to Editor.

Mike Wilday

Admins have access to edit locked cells. I second VAcePro's suggestion. Lower the other user's access to editor and that will prevent them from editing locked columns or rows.

steve50951

Will do. Got it thanks!

Mike Wilday

Glad I could be of service.

Alejandra

Hi Steve,

I'd suggest creating templates of sheets containing formulas —that way you can recover your formulas from the template if they get deleted. More on this here: https://help.smartsheet.com/articles/522123-creating-using-templates

I'd also suggest scheduling a recurring backup to have a copy of your data. Keep in mind backups don't preserve formulas due to the differences between Excel and Smartsheet formula syntax, but they're great to have incase your data goes missing. If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/506499-back-up-your-data

Sign in to join the conversation!

Quick Links

Trending discussions

APPROVAL SETTING VIA "ADVANCED OPTIONS" - APPROVAL WORKFLOW
Hi All, Need you support for the the issue. I was in the process of making an approval workflow for petty cash request, the problem was when i want to combine 2 different confirmation workflow by Requester to be appear in same column (Confirm), but mention notification like in the screenshot attached. The workflow consist…
Metric Widget data source from a report
A report is not available to be a data source for a Metric Widget. I have a report that shows the one figure I want to be displayed on a dashboard. I cannot convert the report to a sheet and cannot seem to get the report number on my report to the Metric Widget… Can this functionality be added to use a report for a data…
Automation not working
I have a Smartsheet automation setup to reminder the planning to complete their sections. It is setup to remind weekly until completed box is checked. They received 2 reminders and then the reminders stopped. Any idea what could be wrong? I can't tell that anything has changed in the sheet. Thanks Freda