Formula help
I have a formula set to change to RYGB balls depending on children. The formula is as follows:
=IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Yellow") > 1, "Yellow", "Green")))
This formula works great.
I now want to add another statement to this that will change the ball to BLUE, i.e;
When all children are complete (Blue), change to "Blue".
I can't seem to figure this out. What is the operator for "ALL"?
Comments

=IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Yellow") > 1, "Yellow", IF(COUNTIFS(CHILDREN(), "Blue") =count(children()),"Blue","Green"
give that a try and see what it gives you.

Works perfectly! Thank You
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 142 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!