Parent Row Counting Problems
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
-
Ok, I think I just solved it doing a Counter column with Ancestors instead of Children....Then did a summarize if Ancestors = 0 resulting in all Level 1 rows
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!