CHECKBOX CONDITIONAL

C. Srinidhi Ragunathan

I have a task and few subtasks that have a column which is of checkbox format.

I need to create a condition, such that, if all the check boxes for the subtasks are ticked, then the check box for the main task should also be ticked, else it should be left unchecked. 

I tried to apply the following: 

IF(AND(SUBTASK1:SUBTASK5) = 1, 1, 0)

However it is not working. 

Please refer to attached image for reference. 

 

Andrée Starå

Hi,

Try this.

Place the below formula in the parent checkbox cell.

=IF(COUNTIF(CHILDREN(), 0) > 0, 0, 1)

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

C. Srinidhi Ragunathan

Thank you

It worked!

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée