Why am i getting a "0" added to the front of some Apparatus or Unit

Troy Bjelland

I am getting a zero added to front of some Unit Numbers which are generated via a formula from other cells. Any help would be appreciated.

Paul Newcome

The first two columns (at least) are blank. Blank "plus" blank equals zero. Once it finds a cell with text in it then it will start adding the text strings together.

Try this instead...

=JOIN(COLLECT([Box Springs]@row:Walsh@row, [Box Springs]@row:Walsh@row, @cell <> ""))

Paul Newcome

The first two columns (at least) are blank. Blank "plus" blank equals zero. Once it finds a cell with text in it then it will start adding the text strings together.

Try this instead...

=JOIN(COLLECT([Box Springs]@row:Walsh@row, [Box Springs]@row:Walsh@row, @cell <> ""))

Troy Bjelland

That worked perfect!!

Thank you so much for the help. I was way off! LOL!

Paul Newcome

Happy to help. 👍️