Indicating status of Children cells


Hello - we have a sheet with Health symbols for the Tasks which are children under Phases of a project. I'd like to be able to indicate on the parent cells of the Health column if there is a non-green symbol among their Children cells in the Health column. Preferably the result is either nothing or a Yellow symbol. Here are my unparseable formulae attempts:



Any advice is welcome.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!