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))))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!