Auto-Lock All the Child Rows

Nasir@EBC

Hi All 

I know how to lock a row when a certain condition (or a set thereof) is met. But is there a way that when a row gets auto-locked, all its child-rows also get locked automatically?

In other words, some kind of inheritance mechanism. 

Thanks in advance!

Nasir

Andrée Starå

Hi Nasir,

I'd recommend using a so-called helper checkbox column and add the below formula to the children. It will check the box when the parent is checked.

=PARENT()

Would that work?

I hope that helps!

 

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD