IF formula for Status of Child

heather48261

Hi - I'm looking for a formula that will display "All tasks complete" in the Parent Status cell, if the Status of all Child tasks is set to "Complete" (and will display "Incomplete Tasks" if any Child tasks have any other status).  

Shaine Greenwood

Hi,

Try an IF statement with a COUNTIF function like the following:

=IF(AND(COUNTIF(CHILDREN(), "Complete") > 0, COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN())), "Complete", "Incomplete Tasks")