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"))


Best Answer


  • Jeffry Lusiak
    edited 08/31/20

    Thanks David!

    Case 2 solved it!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!