Formula to Show Data from Child Row on Parent Row

Options

Greetings -

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


Example:

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

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    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.

    Work?

    Mark


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

  • Andy Lorance
    Andy Lorance ✭✭✭✭
    Options

    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.

    Thanks!

    Andy

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!