# Join and Left Formulas

Options
✭✭✭✭✭

I am trying to Join three columns, the first two are full names the third is a auto generated number. I need the first letter of each column and then the number. I've tried to use Join and Left but it is not working for me, the Join work or the Left works, but combining them is not working.

The N Section below is the result I want to achieve and it needs to be a column formula. Thx

• ✭✭✭
Options

what about something like this ?

=LEFT(University@row; 1) + LEFT(Location@row; 1) + "-" + [Course Number]@row

or make 2 helpers

UniHelper

=LEFT(University@row; 1)

LocHelper

=LEFT(Location@row; 1)

=JOIN(UniHelper@row:LocHelper@row; "") + "-" + [Course Number]@row

then hide the helpers :)

maybe there is a more compact way but thats how i do it atm till i get more knowledge :)

hope it helps :)

• ✭✭✭
Options

what about something like this ?

=LEFT(University@row; 1) + LEFT(Location@row; 1) + "-" + [Course Number]@row

or make 2 helpers

UniHelper

=LEFT(University@row; 1)

LocHelper

=LEFT(Location@row; 1)

=JOIN(UniHelper@row:LocHelper@row; "") + "-" + [Course Number]@row

then hide the helpers :)

maybe there is a more compact way but thats how i do it atm till i get more knowledge :)

hope it helps :)

• ✭✭✭✭✭
Options

As always the community has helped me find or rethink a different approach. This worked, thank you.

=JOIN(LEFT(University@row, 1) + "" + LEFT([Location/Site]@row, 1) + "-" + [Course Number]@row)

• ✭✭✭
Options

Happy to help :)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!