Change project status in Parent Row

Joseph Aloysias

I would like to change the parent row automatically if the status is changed other than "Planned" & "On Hold" in the status column, Please help me with the formula to achieve this.

if all the tasks are completed it should change the status to completed otherwise it should be "in progress"

Amit Wadhwani

Hi @Domnic Victor

You can use the formula below in the parent row to change the status to "Complete" if all the child tasks are complete. If any of the child task is not marked as complete, the parent will show "In progress"

=IF(COUNTIF(CHILDREN(), "Planned") > 0, "In progress", IF(COUNTIF(CHILDREN(), "On Hold") > 0, "In progress", IF(COUNTIF(CHILDREN(), "In progress") > 0, "In progress", IF(COUNTIF(CHILDREN(), "Completed") > 3, "Completed"))))

Joseph Aloysias

Thank you Amit Wadhwani