Lock Cell depending on conditions

[Nad]

I agree that this “solution” is hacky and doesn’t work well in most cases.

I have written out a proposal for formulaic disabling of cells, and would love to have your vote !

Make "Disable If" available to all columns, not just buttons

Time and again I find myself longing for this simple and yet powerful feature: Please let us have “Disable If” for all columns type, not not just buttons. How it should work: For every cell in the column where the formula in “Disable if” evaluates to true, the cell becomes uneditable by the user. The cell retains its value which remains accessible by formulas. The value just cannot be manually edited by users. When a cell is a disabled in this manner, actions like ModifyRow() should throw a…