Counting Children on Multiple Criteria

Nasir@EBC
Nasir@EBC ✭✭✭
edited 01/10/20 in Formulas and Functions

Hi all

I am using the following formula in a parent row which has 10 child rows:

=IF(COUNTIF(CHILDREN(), "Complete") < 10, "Not Done", "Done")

It shows Done as soon as all the children rows have the word Complete in them.

Now I want this formula to favor 2 conditions for "value_if_true" part of the "IF" function:

if all the child-row values are EITHER Complete OR N/A, it should consider it as Done only.

Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!