Counting cells with no blanks in a child column for multiple parent sections.
I have students(CHILD) categorized by University (PARENT) on one Smartsheet. I want to get the total number of students for that school in my sheet summary field. I was able to reach this with this formula. Here is an example of my Smartsheet:
Answer: 2 which is CORRECT! Yeay!
I need to add up 2 of the schools totals together, CSUEB 1 + 2. I thought this formula below would work but it does not:
=COUNTIFS(CHILDREN([Schools]1), NOT(ISBLANK(@cell)), COUNTIFS(CHILDREN([End Date]4), NOT(ISBLANK(@cell))))
Answer: 2 but it should be 4
Can anyone help?
Help Article Resources
Check out the Formula Handbook template!