Heirachy formula

penny53731
penny53731 ✭✭
edited 12/09/19 in Formulas and Functions

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?

               

                            

                            

Tags:

Comments

  • Andrée Starå
    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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!