RYG Formula for Parent and Children Rows
Hello,
I am trying to create a formula where the parent health turns Red if there is more than 3 red children health's, Yellow if there are more than 3 yellows, Blue if everything below it is Blue and the rest of the time green.
Is this possible?
I was using this formula for a while, but realized major gaps and it wasn't actually doing what we needed it to be doing.
=IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") , > 1 "Yellow", IF(COUNTIFS(CHILDREN(), "Yellow") > 1, "Yellow", "Green")))
Best Answer

Try something like this...
=IF(COUNTIFS(CHILDREN(), "Red") >= 3, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") >= 3, "Yellow", IF(COUNTIFS(CHILDREN(), "Blue") = COUNT(CHILDREN()), "Blue", "Green")))
Answers

Try something like this...
=IF(COUNTIFS(CHILDREN(), "Red") >= 3, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") >= 3, "Yellow", IF(COUNTIFS(CHILDREN(), "Blue") = COUNT(CHILDREN()), "Blue", "Green")))

Yes! thank you. I tried the = sign, but i had it before the greater/less than signs.

Yes. Those signs must be in a specific order for them to work.
"<=" will work, but "=<" will not.

Hi Maria,
You might be interested in the formula we created for using Column Formulas in sheets that use Row Hierarchy https://www.smarterbusinessprocesses.com/gettogripswithnestedfunctions/

@Gwen Rymill SBP Thank you! I will check that out!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!