Sheet Summary won't count only rows with no ancestors

Chris Armstrong
Chris Armstrong ✭✭✭
edited 09/16/20 in Formulas and Functions

Can't seem to figure this one out. I would like to count rows that have a Status of 'Complete', and are not a child of another row. My formula is this:

=COUNTIFS(Status:Status, "Completed", Status:Status, ANCESTORS() = 0)

What am I missing? It keeps returning just zero. I've tried pointing the second range at the 'Task' column where the parent/child hierarchy is located, but nothing changes. I've also tried just

=COUNTIF(Task:Task, ANCESTORS() = 0)

but that didn't work either.

Appreciate any help. Thanks.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!