Sign in to join the conversation:
i.e. if a cell looks like
A
B
C
How to get A, B and C into separate cells?
Hi myi,
You've got two ways to do this:
Is there a reverse to this solution? Say I have multiple rows that I want to have linked into a single cell.
Yes if you use this formula. =[column name]@row + " " + [column name]@row. You can do this for 2 cells for sure. Unsure if more than that. In the cell you want the data to merge do = then click on the cell with the first set of data. Add a + sign. Then add + and click the second cell. The + sign pulls them together. If you require a space or other identifier between the data " " puts a space between the two or add in your identifier between the " ". We used this to combine first and last names from a data import. If you then right click the cell and annotate it to be a column Fx it will continue to do that for the entire sheet. Hope this helps.
I'm trying to work on automating lines on Smartsheet and implement copy row feature. When I click on the COPY TO field and try to search for a specific sheet for "select a destination sheet", it's not coming up. What could be the potential issues? I've seen the sheet not pop up on search for a few hours after creation, but…
Hello! I see there was recently changes made to the login screen. When I began using this program for work, I was a regular user. I eventually was added to my company's enterprise account for the premium functionality. I used to select "Log in with company account" to utilize this access. Since the changes were made to the…
Good morning! With all the changes in the University, it appears there is no self-paced Blueprint training anymore, and the only way to learn is through an instructor-led course at $1800 or a $3000 pass. Is that correct or am I missing something?
