COUNTIF on FLAGS at PARENTS level not returning any value (number)
Hi Smart Community,
I am trying to Sum my CHILDREN() Countif but it is not giving any value. All my sub-children is indicated as flag (1 or 0)
Example
When there is a delay release in a category Bug Fix : it will flagged out RED. On Bug Fix, I did
=COUNTIF(CHILDREN()),1)+""
This seems to work fine and return with 2 (which is the total number of flagged items in Bug Fix). See below screenshot.
Obviously, I have 5 different categories and on a Parent level for all these categories, I would like to sum all categories flag but it doest return a value.
On the darker green : it should be counting (2+3+0+0+1) = 6 but I am not sure what formula i should be using? I have tried the following
=SUM(CHILDREN(),1) - return result as Red Flag
=COUNTIF(CHILDREN(),1)+"" - return result as 0
=SUM(CHILDREN()) - return result as White Flag
=SUM(CHILDREN(),1)+"" - return result as 1
Thank you in advance, and hope you are all having a great day so far :)
Syed
Best Answers
-
The reason the SUM function does not work is because when you add + "" to the end of a formula, the numbers are converted to a text value. Try counting the DESCENDANTS...
=COUNTIFS(DESCENDANTS(), 1) + ""
-
Happy to help! 👍️
Answers
-
The reason the SUM function does not work is because when you add + "" to the end of a formula, the numbers are converted to a text value. Try counting the DESCENDANTS...
=COUNTIFS(DESCENDANTS(), 1) + ""
-
Thank you Paul! This works like a champ. The descendants function is pretty new to me so this is great to know!
-
Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!