Summarize child information in parent row?

gr_rh_sheet

Hi - I'm trying to write a formula that would group and summarize information from children rows into a cell in the parent row and I keep running into issues.

I have a "Dropdown (Multiselect)" column for "Work type" that has the available values of Web Design, Copy, Video, Animation. Any row can be one or any of those selections. I have a helper column named "workTypeSummary" where I'd like to use a formula to summarize all the work types of the children, in the parent row. Is this possible? The formula below that I'm using currently only shows 1 value regardless of different values in other child rows. For example I have a parent with different rows of Copy, Animation and Web Design - but only Copy is appearing in the cell with my formula below.

=IF(AND(CONTAINS("Video", CHILDREN([Work type]@row))), "Video", IF(CONTAINS("Copy", CHILDREN([Work type]@row)), "Copy",IF(CONTAINS("Web Design", CHILDREN([Work type]@row)), "Web Design", IF(CONTAINS("Animation", CHILDREN([Work type]@row)), "Animation"))

Paul Newcome

If you make the helper column a multi-select, you can use this...

=JOIN(CHILDREN([Work Type]@row), CHAR(10))

Paul Newcome

If you make the helper column a multi-select, you can use this...

=JOIN(CHILDREN([Work Type]@row), CHAR(10))

gr_rh_sheet

Wow - thank you. That worked!

Paul Newcome

Happy to help. 👍️