Join and Left Formulas
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
Best Answer
-
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)
and for your output field
=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 :)
Answers
-
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)
and for your output field
=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 :)
-
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)
-
Happy to help :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!