Juggling balls in Smartsheets

Project management is at least in part greatly eased by the right tools. One of those tools I use today with customers is https://www.smartsheet.com/

And this one comes in handy to summarise RYGB balls of the item's chilrdren :)

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

This 'll get updated more as things evolve ;)


Random links of note