JOIN(DISTINCT(COLLECT not separating names on list.

I've created a complicated cross-sheet formula with several different reports. What I'm trying to do now is have a sheet populate whatever information is found in Range 1 if it meets the conditions mentioned. This is the formula I used:

=JOIN(DISTINCT(COLLECT({2020 CSTE Media Tracking Range 1}, {2020 CSTE Media Tracking Range 2}, Outlet@row), "; "))

Even with "; ")) some of the names are not separated and it becomes confusing to read. This is the sheet it's pulling from and how the names are listed, for reference:


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!