what is the best way to combine contacts from children rows into parent row?


In a contacts column, I would like to combine email addresses that are in 2 children rows into their parent row. I have a helper column that checks a box of the children rows using the formula: =IF(COUNT(ANCESTORS([Protocol ID]@row)) > 0, 1)


  • BullandKhmer
    BullandKhmer ✭✭✭✭✭


  • MarieM
    MarieM ✭✭

    Thank you! How would I apply this to all parent rows and newly added rows?

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @MarieM

    If you are manually entering in contacts to the cells below, there isn't a way to make the formula auto-apply to Parent rows. This is because either you can have a formula in the cell OR you can manually make changes, but you can't do both.

    What I would personally do is collapse all the Parent rows (right click on the column title > Collapse All) then drag-fill the formula down the Parent row cells.

    Keep in mind that Contact type values cannot be combined together using a formula to output multiple contacts, so this will just show the Contact names as text values:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!