Conditional lock

Alejandro Villegas

Hello,

 

I am trying to develop a shareable sheet in which some tasks are listed along a row and check boxes are used to indicate a task has been completed.

 

Would it be possible to lock these checkboxes if its previous one haven't been checked?

In this way a process flow would be enforced.

 

Perhaps the solution would include an IF statement, but I haven't been able to produce the results that I need.

JamesR

It is not possible to dynamicl  lock cells. You can only lock Rows or Columns and you need to be an administrator to do it.

You could do something with conditional fprmatting using Red Yellow Green colours to colour the cell according to its requirements i.e. Red if they should not dai anything. Yellow if they can do changes and Green when they have done them.  You can also create a symbol column and again using Red Yellow green balls and write if function  to change colour as required similar to above.  The symbol column should be locked once created.