Lock single cell

ygoldgrab · 09/13/22

It would be very useful to lock a single cell.

I see it's been asked many times on the community but I did not find anyone submitted it as an idea

ker9 · 09/20/22

This is dependent upon what you are trying to achieve, but you might be able to put that single piece of data in a locked summary field, which can be referenced in formulas.

ygoldgrab · 09/20/22

In my particular case, I had put defaults in my Navigation and Summary headers so that Sorting the columns would still keep the Navigation section in place. (I had formatted the defaults to be unseen by making the font and background the same as the Navigation header).

The Issue that keeps happening is that my users delete the defaults and the navigation header ends up in middle of the sheet!

If only I can lock those cells with the defaults!

dhall · 01/10/23

I'm adding to this, I would like this feature to lock very specific cells that have a formula in it.

An example would be this formula we use for Parent Cell and their Status based on Children Status:

=IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), "Complete"), "Complete", IF(OR(CONTAINS("In Progress", CHILDREN()), AND(COUNTIF(CHILDREN(), "Complete") > 0, COUNTIF(CHILDREN(), "Not Started") >= 0, COUNTIF(CHILDREN(), "Upcoming") >= 0)), "In Progress", IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), "Upcoming"), "Upcoming", "Not Started")))

Another example is a formula I've seen (but not used) for Parent Cell Checkboxes. I can't find it right now, but it essentially counts the children and shows "5 of 7".

We don't want to lock the row as the owner may change, or we need to add to a task description, and we don't want to have to go through the process of locking and unlocking the row.

dhall · 05/25/23

Hey all, I saw this was updated so I wanted to include my additional use case for locking a single cell.

I mentioned in my previous post we have a formula that we use on checkbox/flag columns that allows the Parent to count the children and quickly show us summary.

Formula: =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN())

Pretty straight forward formula. The results would come out like the below screenshot:

This would be a cell that we would lock.

ksmith1 · 07/27/23

Having the ability to lock the content at the cell level would be a great thing to add. There have been times when a team member accidentally edited a cell that I had entered a formula into and I had to re-enter the formula. Being able to lock down a particular cell would prevent this.