IF Formula for Value of Child@row and Descendants
I need a column formula to display the value(s) of the children up through all the parents. The JOIN part of the formula below does this. However, if the child doesn't have a descendant value in it, I want it to display the value from that row. The first part of the formula below is what I was hoping would take care of that. But, I receive the error message: #INCORRECT ARGUMENT SET.
Any ideas of a solution for this formula? Thanks much!!
=IF(COUNT(DESCENDANTS(Accountable@row), "0", Accountable@row, JOIN(DESCENDANTS(Accountable@row), CHAR(10))))
Help Article Resources
Check out the Formula Handbook template!