Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Is there a way to display the value of a cell from the last row of children in a given parent row cell?
https://app.smartsheet.com/b/publish?EQBCT=88d458a7fd8d41b5b41347575bd6eccd
I hope this helps.
https://app.smartsheet.com/b/publish?EQBCT=d21382f4fca349ae9eaa3c7d77604c83
This one is editable
Awesome! Thanks. I'll give it a try. Looks promising.
Yep. Worked perfectly. Thank you!
Glad to hear it.
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
Good catch thanks for checking behind me lol I didn't even think about it having the possibility of being blank
I wasn't checking, I was making sure I understood the concept. But you are welcome.
