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!
Best Answer
-
All symbols have a text value that allows them to be referenced in formulas. I went ahead and looked up the symbols you used and found this:
In your case you would need to replace "Red" with "No", "Yellow" with "Hold", and "Green" with "Yes".
NOTE 1: This is case sensitive. "no" will not work, but "No" will.
NOTE 2: All symbols will have different text values. You can find them by clicking on the dropdown arrow in a cell after setting the column type as the symbol of choice.
Answers
-
You will need to change the text in bold to match the symbols you are using, but here is the proper syntax:
=IF(CONTAINS("Red", CHILDREN()), "Red", IF(CONTAINS("Yellow", CHILDREN()), "Yellow", "Green"))
-
@Paul Newcome I tried that but I end up with the word (eg. "Green", "yellow" etc.) in the cell instead of the actual symbol.
Also, I don't understand your comment on changing the text in bold. Please clarify. Thank you.
-
All symbols have a text value that allows them to be referenced in formulas. I went ahead and looked up the symbols you used and found this:
In your case you would need to replace "Red" with "No", "Yellow" with "Hold", and "Green" with "Yes".
NOTE 1: This is case sensitive. "no" will not work, but "No" will.
NOTE 2: All symbols will have different text values. You can find them by clicking on the dropdown arrow in a cell after setting the column type as the symbol of choice.
-
@Paul Newcome That worked! Thank you!
Is there a way to automate this so when children are added, or multiple child levels are added to parent that formula will get added to a parent row automatically?
-
You are going to have to manually add the formula to each parent row, but it will automatically take into account any new child rows that are added.
Help Article Resources
Categories
Check out the Formula Handbook template!
