Remove Extra Commas in Join/Collect?

SYSPK
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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!