I want to get a nested formula counting children colors but I'm missing What I'm doing wrong
I'm not an expert on formulas , so I took this one from a different post I found which I believe cover my needs
=IF(COUNTIFS(CHILDREN(), "Red") > 0, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") >= COUNTIFS(CHILDREN(), "Green"), "Yellow", "Green"))
The thing I need to do is to count if there is at least one color Red, mark it as Red, if none, keep looking at Yellow and set it as Yellow, if none of the above set it as Green
When I validate the formula, it is only returning "Green"
Appreciate if someone can point me to the right direction.
Answers

CHILDREN() looks ONLY one level down from your current row. All dots on your two "2nd level" rows are green, meaning the parent will always be green. You can either:
 Use your existing formula, but also copy it to your second level entries as well. The second level entries will then calculate based on their children, and then those results will roll up to the top level.
 Replace all CHILDREN() references in your formula with DESCENDANTS(). DESCENDANTS looks at all levels below current.
Either of these will work, but will give you different results.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.4K Get Help
 61 Global Discussions
 46 Industry Talk
 384 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!