Have children() that vary in range, children rows can vary from 1 to ~30.
For each child that contains "Action" in column [Issue Category] display the cell Notes contents into parent row Notes cell.
Currently using static formula. Issue is every time a row is inserted, I have to manually add to the formula.
Current formula example:
=IF([Issue Category]196 = "Action",Date196 + ": " + Notes196 + SUBSTITUTE(Notes1, "-", ""), "") + IF([Issue Category]197 = "Action", Date197 + ": " + Notes197 + SUBSTITUTE(Notes1, "-", ""), "") + IF([Issue Category]198 = "Action", Date198 + ": " + Notes198 + SUBSTITUTE(Notes1, "-", ""), "") + IF([Issue Category]199 = "Action", Date199 + ": " + Notes199 + SUBSTITUTE(Notes1, "-", ""), "") + IF([Issue Category]200 = "Action", Date200 + ": " + Notes200 + SUBSTITUTE(Notes1, "-", ""), "")
Any help would be greatly appreciated.