JOIN formula to ignore cells in blank

Jean Kim

Hi Trying to get below formula work.

=JOIN(Reedev@row:Yisan@row, Reedev@row:Yisan@row, NOT(ISBLANK(@cell), "| "))

Expected results are on the lat column. Formula above is returning "Incorrect argument set" error. What am I doing wrong. Please help

Andrée Starå

Hi Jean,

You’d need to use a JOIN COLLECT combination instead.

Something like this.

=JOIN(COLLECT(Reedev@row:Yisan@row, Reedev@row:Yisan@row, <>""), "| ")

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Jean,

You’d need to use a JOIN COLLECT combination instead.

Something like this.

=JOIN(COLLECT(Reedev@row:Yisan@row, Reedev@row:Yisan@row, <>""), "| ")

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jean Kim

Thanks Andree for your feedback. I tried. But result comes out based on count.

Result with your formula

Result I am looking to see is

Thanks!

Andrée Starå

Happy to help!

Strange!

I tested it and it should work.

Can you try it on another row with multiple values?

Did that work?

Jean Kim

Woot. My bad. It works!

Sorry sorry and Thanks x 100. =D

Andrée Starå

Haha!

No worries!

You're more than welcome!

thomas.depascale

How can I incorporate this into my formula?

=JOIN(COLLECT([Serial Number]@row:[Serial Number 20]@row, [Serial Number]@row:[Serial Number 20]@row, FIND(LEFT(@cell, 4), "Q2AX^Q2BX") > 0), ",")

This produces "," from blank cells that I need removed. I can't seem to find the right place to put this into the formula.