Sign in to submit new ideas and vote
Get Started

Lock single cell

ygoldgrab ✭✭✭✭✭

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

47 votes

On Radar · Last Updated

Thank you for the suggestion and feedback! While this is not currently in our plans, we are definitely interested in understanding how this capability would improve the way you work. Please continue to share examples and use cases as we investigate this further.


  • ker9
    ker9 ✭✭✭✭✭✭

    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
    ygoldgrab ✭✭✭✭✭

    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
    dhall ✭✭✭

    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
    dhall ✭✭✭
    edited 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
    ksmith1 ✭✭

    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.

  • Being able to lock a cell could help constrain hard deadlines with adjustable predecessors.

  • Trish Dillon
    Trish Dillon ✭✭✭✭✭✭

    🔐 🏁 in our use case - we will need a cell to auto-lock based on month-end closing for financials after data is entered and approved.

  • Carrie Barnett
    Carrie Barnett ✭✭✭✭

    Sometimes, I need to lock just one cell rather than a whole row - it would be great to be able to do so.