Join Function Returning Several blank values

I have read a ton of other posts on this, but none of the solutions are working on my issue. I have several other sheets working together, and I am attempting to join the values on one sheet based on an if statement in another.

Here is the formula that returns the blank values: =JOIN({Home Church Kids Volunteers Range 2}, ", ")

Here is a formula that I attempted to make based on other posts that is returning #incorrect argument set: =JOIN(COLLECT({Home Church Kids Volunteers Range 2}, <>""), ", ")


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!