# 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?

Example

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

Stéphane

## Answers

• ✭✭✭✭

Hi Genevieve,

Thank you for this great insight. It is very helpfull in solving my query.

Kr

Stéphane

• Employee Admin

Great! Glad I could help.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!