Remove Extra Commas in Join/Collect?

SYSPK ✭✭✭✭✭✭

I have a great formula of JOIN and COLLECT together that pulls info from 11 columns. It pulls strings if they meet certain conditions with commas as a delimiter.

But if the conditions are not met, I have a bunch of commas next to each other. E.g. , , , EX1, , EX4, , , , and in some cases, just 11 commas.

Is there a way to only show the strings if they meet the conditions, keep them separated by commas but then nothing else? I.e. if there are 2 commas next to each other, to not show in the cell. I'm willing to use a helper column for this. The e.g. above would look like "EX1, EX4" and if there are no conditions met, the cell would be blank.

Thank you


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!