Heirachy formula

penny53731

I have a parent line with children underneath. I have a status column with red,yellow and green. 

Say I have 6 children lines under the parent line . I need for the status on the last entered children line to reflect on the parent line. 

If you close the Heirachy I will know what the last status was that was entered. 

Is there anyone able to help me with the formula?

               

                            

                            

Andrée Starå

Hi Penny,

Try something like this. Add the formula to the parent cell.

=INDEX(CHILDREN(); COUNT(CHILDREN()))

The same version but with the below changes for your and others convenience.

=INDEX(CHILDREN(), COUNT(CHILDREN()))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting