Formula COUNTIF(Children) with multiple conditions

In Smartsheet, there is a function called Countif(CHILDREN([reference])). This is a great formula but what if I wanted the count of children based on more than 1 condition?

I searched in the knowledge base, but couldn't find either a 'countifs(children)' formula nor a workaround.

Is there a workaround?


In this example, today's date is 15/01/2020

If you apply the formula CountIf(Children([Complete %])), the number of children would equal 6.

What I would like to count are the children which are not 100% completed before today's date. 

So a countif based on 2 conditions. In this case I should have a count of 1 child.

Best regards


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!