Parent Row Counting Problems

Options

Hello all, I'm having an issue with counting parent rows the way I require.

Problem so far: I've created a Counter column where I have summarized the Main Project column to give me all rows with Children greater than 0. Then I used a CountIFS formula for greater than zero and assigned to a specific person.

The Issue I'm facing is that these formulas don't return all parent rows. It returns parent rows that have children, but doesn't reflect the projects with zero parent rows. When I try to do greater than or equal to 0 in the formula, then it returns all rows with children.


Any advice would be great!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!