JOIN(COLLECT formula showing blank cells

I have searched the forums and tried several different variations of the JOIN(COLLECT formula, and this one is the only one that doesn't give me an error.

I am trying to combine rows that have duplicate locations. The duplicate is flagged in "Column 23" (helper column). So I want the duplicate rows to move to another sheet and join all of the cells on that sheet. The way I have it now, it returns a blank cell.

What am I doing wrong?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!