Using COUNTIF children to change a Status with multi criteria
In our Timing and Action we have a formula that indicates the status of a Parent row based off the cumulative Status choices (Not Started, In Progress, Complete, N/A) of the Children Rows below it.
How do I get the formula to register the Parent Row 'Complete" when the CHILDREN Rows = both Complete and N/A
I want to account for tasks in the rows that are marked "N/A" to count as complete in the formula below:
=IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", "In Progress"))
Help Article Resources
Check out the Formula Handbook template!