Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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.
Hello,I would like my Children Cells to fetch their value from the Parent cell.Is it possible?Will it be possible soon?NB - I do not want to fetch the value from the "cell reference" of the parent ("=[Related Invoice]1 ")
I love this idea, Julien! I agree it would be useful to have a PARENT() function. This does not exist yet in the app but I will add your vote for this to our enhancement request list.
Julien,
Here's my work-around
The formula in the ParentRow determine if the row is a parent or has no children.
The formula in the GetParentValue will use the value from the Value column if it finds a parent, otherwise get the value from the row above.
Depending on how you want to lay out the data, I have also just put the formula in the Value field and overwrite it for the Parent rows.
A gotchas:
- Formula expects to start on Row 2 - but one could just deleted that part of the formula for the top row if necessary.
I use the formula in the ParentRow a lot for conditional formatting of header rows.
Hope this helps.
Craig
