Fetching Parent Cell value for Children Cells

Julien

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

 

Travis

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. 

J. Craig Williams

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