Combining Join Collect & Children Functions
I'm trying to join all the values in children rows only if another column criteria is met. Here's what I have so far and thought should be working.. =JOIN(COLLECT(CHILDREN(), [Top 10 Keyword]:[Top 10 Keyword], "1"), ", ")
Also, what's kind of strange is the formula works perfectly when I change it to =JOIN(COLLECT(Keywords:Keywords, [Top 10 Keyword]:[Top 10 Keyword], "1"), ", ") the issue is, I only want to join the values in the children rows.
Appreciate the help!!
Best Answer
-
Hey Devon,
I think this formula should work for what you're doing, assuming you only care about the corresponding Top 10 key words that are also on those children rows:
=JOIN(COLLECT(CHILDREN(), CHILDREN([Top 10 Keyboards]@row), =1), ", ")
Hope that helps!
-Alex
Answers
-
Hey Devon,
I think this formula should work for what you're doing, assuming you only care about the corresponding Top 10 key words that are also on those children rows:
=JOIN(COLLECT(CHILDREN(), CHILDREN([Top 10 Keyboards]@row), =1), ", ")
Hope that helps!
-Alex
-
Thanks Alex! That did the trick 😅
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 383 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!