Joining Child Rows if meets Criteria

Jeanna Wright

I am attempting to write a formula in which I want to join child rows from a column titled "Assigned Workgroups/ Work Teams" if the child row has "On Hold - Pending Add'l Info" selected from a column titled "Decision Status." The outcome should be a list of workgroups/work teams on the parent row if the decision status is on hold in the column "Child On Hold Status."

I have attempted functions JOIN, COLLECT, IF, plus more. Please help!!!!

Thanks,

Jeanna

Paul Newcome

You would need something along these lines...

=JOIN(COLLECT(CHILDREN([Assigned Workgroups/ Work Teams]@row), CHILDREN([Decision Status]@row), @cell = "On Hold - Pending Add'l Info"), "delimiter of choice")

Paul Newcome

You would need something along these lines...

=JOIN(COLLECT(CHILDREN([Assigned Workgroups/ Work Teams]@row), CHILDREN([Decision Status]@row), @cell = "On Hold - Pending Add'l Info"), "delimiter of choice")

Jeanna Wright

Still coming up unparseable. Any other thoughts?

Jeanna Wright

NM!!! Got it!

Heather_Verde

Is your Assigned Workgroups/ Work Teams the Primary column?

Jeanna Wright

No, I got the formula to work that Paul suggested. I somehow deleted a comma originally and just wasn't seeing my own error.