Combining Join Collect & Children Functions

Devon Eddy
Devon Eddy ✭✭
edited 09/22/20 in Formulas and 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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!