R,Y,G and G - Part 2

Hey @Paul Newcome / @Andrée Starå ,

Well if you dont mind helping, i'll ask another question :-) Started a new thread for others that might want to see it as a separate request.


In a nutshell, at the parent level, I'd like the "current health" (R, Y, G, Gray) to be the color of the highest risk child (or gray if there is no movement). Priority would be Red then Yellow then Green. Gray if all the children are gray. In other words, check for the Highest risk, if there is one then roll up to and make the the Parent that color.


Here is the formula that works great - the only issue is that the Gray isnt incorporated in the formula. Can you help incorporate the gray?

=IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", " ")))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!