Joining Child Rows if meets Criteria
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
Best Answer
-
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")
Answers
-
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")
-
Still coming up unparseable. Any other thoughts?
-
NM!!! Got it!
-
Is your Assigned Workgroups/ Work Teams the Primary column?
-
No, I got the formula to work that Paul suggested. I somehow deleted a comma originally and just wasn't seeing my own error.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!