Formula for RYG Symbols in Child Rows to Update Parent Row
Hello, I'm wondering if there's a formula that could automatically update the parent row in a column that has RYG symbols?
The parameters would be:
-Green overall (in the parent row) if all children rows have green symbols?
-Yellow overall (in the parent row) if any children rows have at least 1 yellow symbol?
-Red overall (in the parent row) if any children rows have at least 1 red symbol?
In addition, I'm wondering if it would be possible to apply this formula to the column, so that the users of the sheet wouldn't have to apply this to each parent row each time a new parent row was created?
Help Article Resources
Check out the Formula Handbook template!