Join Function Sometimes Adds Two Columns rather than Joining

dbrdy

When I use the formula =JOIN([PO number]@row + [Line Number]@row) sometimes the two columns are added instead of joining

For example, I'm trying to join a PO number and line number to create a unique identifier. The Join function adds the two numbers. I have also attached an example.

Join Error SmartSheet.docx

JamesB

@dbrdy Try this...

=JOIN([PO number]@row +""+ [Line Number]@row)

Carson Penticuff

In this use case, you don't need the JOIN function at all.

=[PO number]@row +""+ [Line Number]@row

dbrdy

Thank you both. That worked beautifully.