IF Formula for Value of Child@row and Descendants

Terri1019

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

jmyzk_cloudsmart_jp

Hi @Terri1019

Please change "0" to 0.😁

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

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

Terri1019

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

jmyzk_cloudsmart_jp

Hi @Terri1019

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

jmyzk_cloudsmart_jp

Hi @Terri1019

Please change "0" to 0.😁

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

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

Terri1019

Perfect! Thank you so much!!

jmyzk_cloudsmart_jp

Happy to help.😁

Terri1019

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

jmyzk_cloudsmart_jp

Hi @Terri1019

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

Terri1019

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