Auto-Lock All the Child Rows

Nasir@EBC · 11/14/19

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å · 11/14/19

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

Auto-Lock All the Child Rows

Comments

Help Article Resources

Categories