Status

anjaz

Hello,

I would like to ask something about status. If I have parent and children – all status is 'in progress' or 'not started', and then I marked all children to 'complete', the parent also should be complete. How do I do this?

Thank you in advance,

Anja

Shanky Paul

Hi,

try the below formula in your parent status:

=IF(COUNTIFS(CHILDREN(), @cell <> "complete") = 0, "complete", "in progress")

Thank you!

Shanky Paul

Hi,

try the below formula in your parent status:

=IF(COUNTIFS(CHILDREN(), @cell <> "complete") = 0, "complete", "in progress")

Thank you!

anjaz

Thank you.