# IF Formula for Value of Child@row and Descendants

Hello,

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

• ✭✭✭✭✭✭

=IF(COUNT(DESCENDANTS(Accountable@row)) = 0, Accountable@row, JOIN(DESCENDANTS(Accountable@row), CHAR(10)))

Showing me and my descendants (if it exists) may give some consistency.

=Accountable@row + CHAR(10) + JOIN(DESCENDANTS(Accountable@row), CHAR(10))

One more question maybe you can help with? In one column, I don't want an IF statement. I need the value to come across plus have the value roll up to the parents. In the example below line 1.1.2 Test has Gmail for the technology. With the formula as-is, the value does not carry over to the Technology-Report column because of the IF statement (the value is not 0). Your thoughts on a formula for this? Thank you!!

• ✭✭✭✭✭✭

Do you want to show "Esker Gmail" on the Technology-Report column in the 1.1.2 Test row?

Then,

=Technology@row + CHAR(10) + JOIN(DESCENDANTS(Technology@row), CHAR(10))

Here is a revised demo sheet.

https://app.smartsheet.com/b/publish?EQBCT=ba5cd6a12444436abaf1e2c579718703

• ✭✭✭✭✭✭

=IF(COUNT(DESCENDANTS(Accountable@row)) = 0, Accountable@row, JOIN(DESCENDANTS(Accountable@row), CHAR(10)))

Showing me and my descendants (if it exists) may give some consistency.

=Accountable@row + CHAR(10) + JOIN(DESCENDANTS(Accountable@row), CHAR(10))

• Perfect! Thank you so much!!

• ✭✭✭✭✭✭

Happy to help.😁

One more question maybe you can help with? In one column, I don't want an IF statement. I need the value to come across plus have the value roll up to the parents. In the example below line 1.1.2 Test has Gmail for the technology. With the formula as-is, the value does not carry over to the Technology-Report column because of the IF statement (the value is not 0). Your thoughts on a formula for this? Thank you!!

• ✭✭✭✭✭✭

Do you want to show "Esker Gmail" on the Technology-Report column in the 1.1.2 Test row?

Then,

=Technology@row + CHAR(10) + JOIN(DESCENDANTS(Technology@row), CHAR(10))

Here is a revised demo sheet.

https://app.smartsheet.com/b/publish?EQBCT=ba5cd6a12444436abaf1e2c579718703

• Thank you so very much! That works just as needed!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!