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

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.