Change parent symbol based on children symbols
I'm seeking a formula that will allow the parent symbol to change based on the children symbol. So, if there is a red in any of the children rows, the parent row will show a Red. If there are only yellows, then parent will so yellow, if all green, parent green. Thank you!
Help Article Resources
Check out the Formula Handbook template!