Join Function Sometimes Adds Two Columns rather than Joining


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!