Sign in to join the conversation:
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
Try
=Left(City1, 3) + Number1
OR if your join actually worked, you can also try this...
=Join(Left(City1, 3) + Number1)
Thank you very much!
Hi, I have a dropdown column in a sheet. The column contains 98 separate dropdown values. I've noticed that one of the values (the longest one) doesn't show in the list when trying to filter using the "is one of" or "is not one of" options. All other 97 dropdown values display. This is the name of the value that doesn't…
I have an active automated notification in a sheet of project tasks that lets the "assigned to" know when anything has changed in their row. However, they don't need to know about changes they made themselves so I am trying to eliminate those. I set up a column called "MATCH" and added a formula to check for a match…
Random question for yall on a Wednesday.... Doing some workspace audit and reorganization and need to see if there is an easy way to see what sheets are and are not being used. Within an entire smartsheet workspace, are you able to easily see how many smartsheets that are actively using today / updating consistently? i'm…
