mother cell status

Thanks for the question. Jeff K is correct that this can be accomplished using a nested IF formula and the CHILDREN() function, however it can be a little difficult to get it fully written out to do everything you'd like. The trick to nested IF formulas, is that these formulas will stop and give the result for the first true statement, going from left to right. Here's how this formula can be written to meet all of the criteria it looks like you're looking for:

=IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(AND(COUNTIF(CHILDREN(), <>"-") = COUNTIF(CHILDREN(), "Gray"), COUNTIF(CHILDREN(), <>"-") <> 0), "Gray", IF(OR(COUNTIF(CHILDREN(), "Yellow") > 0, COUNTIF(CHILDREN(), "Gray") > 0), "Yellow", IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), "-"), "-", IF(COUNTIF(CHILDREN(), <>"-") = COUNTIF(CHILDREN(), "Green"), "Green")))))

This formula can be placed in every parent row in the status column. To learn more on nested IF formulas, here's a blog post with more about this (https://www.smartsheet.com/blog/support-tip-build-nested-IF). To learn more about the different functions used in this formula, here's our functions list help center article (https://help.smartsheet.com/functions).