Cell value is cleared easily for a locked column before unlock

FrankW

Hi,

I have a calculated column field and do not want others (including myself) to override the calculation.

So, I made the column as lock column.

However, I was able to clear the calculation or value in the column without UNLOCKING the column.

My expectation is:

- others cannot change the cell values in this column; and

- I need to UNLOCK the column before I change the value of any cells in this column.

Regards

Frank

Find more posts tagged with

Forms

Formulas

Comments

Mike Wilday

Hi FrankW,

Your ability to clear the cell has to do with sheet permissions. Admins, and people shared on sheets as Admins are able to delete the content of locked cells. View this article on sheet permissions to see what is capable with which role a person has been assigned. Because you are an admin, you are able to edit locked cells.

https://help.smartsheet.com/articles/1155182-sharing-permission-levels

J. Craig Williams

Please submit an enhancement request:

https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409

This is my user story:

As an ADMIN allow LOCK (rows and columns) to affect the Admin in the following ways for each Sheet:

- always on (until manually turned off - so same as an Editor)

- reminder (prompt for change when modifying locked items, prompt for disabling for session and for turning off reminder if not disabling it (I want ONE chance to have this choice, not one each time I violate the lock)

- always off (the way it is now)

to give the Admin some protection against their own inadvertent mistakes overriding needed functionality.

This would be a Sheet level configuration property.

Craig

Mike Wilday

That has been my story as well. It would be great to lock the data similarly to Google Sheets where I am warned if I am editing something i have locked. I will submit this enhancement request as well.

J. Craig Williams

Another consideration would be how the configuration affects multiple Admins with access to the sheet, but since this is not something I expect to see from Smartsheet, I don't want to spend a lot of time thinking about it.

Craig

FrankW

Thanks Craig. I have already submitted an enhancement request.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…