LastChild() function?

tonejac

Is there a way to display the value of a cell from the last row of children in a given parent row cell?

L_123

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

 

I hope this helps. 

L_123

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

This one is editable

tonejac

Awesome! Thanks. I'll give it a try. Looks promising.

tonejac

Yep. Worked perfectly. Thank you!

L_123

Glad to hear it. 

J. Craig Williams

Luke_TK,

First: BRILLIANT. Very impressive.

Second: There's a bug. I fixed it.

In case the sheet goes away (and my examples do), the solution works as so

=INDEX(CHILDREN(Example23), COUNT(CHILDREN(Example23)) + COUNTIF(CHILDREN(Example23), ISBLANK(@cell)), 1)

using the INDEX function and COUNT of the number children.

The bug was that there might be blanks in the children. I added the COUNTIF() portion to account for that.

Third: The First is not sarcasm, despite the bug. I really really like that solution. Bravo Zulu.

Craig

 

L_123

Good catch thanks for checking behind me lol I didn't even think about it having the possibility of being blank

J. Craig Williams

Luke_TK,

I wasn't checking, I was making sure I understood the concept. But you are welcome.

Craig