nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Joining 2 columns

Patricia Worth

Hi, i need to join 2 columns. First column is the City Name and second is the Numbers. I got it to work but I only need the first 3 digits from the City : =JOIN(City1 + Number1) comes out CITYNAME3462

I need to show up CIT3462

thank you for the help

Find more posts tagged with

Comments

Mike Wilday

Try

=Left(City1, 3) + Number1

OR if your join actually worked, you can also try this...

=Join(Left(City1, 3) + Number1)

Patricia Worth

Thank you very much!

Sign in to join the conversation!

Quick Links

Trending discussions

Run Generate Document Workflow On Multiple Rows
Hello everyone, I have several rows (different entries) that I would like to enter on a custom form using the "Generate Document" workflow. I did a test run and it just generated "individual" PDF form per row - and not multiple rows merged into one form as I was expected. Is there another way or methodology around this or…
Sharing a Single Smartsheet with External Partners (No SSO Access)
Hi Smartsheet Community, I’m hoping you can help clarify a Smartsheet sharing question. I’m trying to share one specific sheet from my Smartsheet plan with two external colleagues from our partner organization. Several colleagues have mentioned they’ve successfully shared sheets with external partners before, so I’m hoping…
Form Creation
Is it possible to create a form on sheet 1 with information from sheet 2? On Sheet 1, I'm tracking what we ship and receive. On Sheet 2, I'm tracking the shipping requirements. I want to pull data from this sheet for a shipping request form on sheet 1.