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)

Answers

  • BullandKhmer
    BullandKhmer ✭✭✭✭✭

    =JOIN(CHILDREN(), CHAR(10))

  • MarieM
    MarieM ✭✭✭

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

  • 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:

    Cheers,
    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!