Join Function Returning Several blank values

@iamhunterabrams

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}, <>""), ", ")

Paul Newcome

The error message formula is on the right track. You just need to repeat the range. The syntax for COLLECT is

range to collect, 1st criteria range, 1st criteria

You have

range to collect, 1st criteria