Formula to Show Data from Child Row on Parent Row


Greetings -

I am looking for a way to show the data from the first child row onto the parent row.


Parent Row = blank

Child row 1 = blank

Child row 2 = TEXT

Child row 3 = TEXT

The formula on the parent row would yield the text from child row 2


  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi @Andy Lorance ,

    Try entering this in the parent row. Use the right row # for your sheet:

    =IF(NOT(ISBLANK(Child1)), Child1, Child2)

    If you need to go down more child rows you can repeat the IF statement until it find a cell that is no blank.



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Andy Lorance
    Andy Lorance ✭✭✭✭

    Hi, Mark - thanks for the reply!

    The sheet data is dynamic; the parent rows will move around as a result. I'm hoping to find a solution that I can convert into a column formula.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!