Hi,
I have this formula that works when automating parent/child tasks in a project plan.
=IF(COUNT(CHILDREN(formula@row)) > 0, IF(COUNTIF(CHILDREN(formula@row), "Complete") = COUNT(CHILDREN(formula@row)), "Complete", IF(COUNTIF(CHILDREN(formula@row), "Not Started") = COUNT(CHILDREN(formula@row)), "Not Started", "In Progress")))
This allows parent tasks to auto populate depending on child tasks
If all child tasks are complete = Parent task is complete
If all child tasks are not started - Parent task is not started
if all child tasks are in progress= Parent task is in progress etc
I would like to add the following criteria to the formula above.
if all child tasks is blocked - Parent task is blocked
If all child tasks is on hold - Parent task is on hold
If there is a mixture of child tasks that are blocked or on hold - Parent task is blocked.
can anyone help with the formula please?
