Hi, I have a list in a column which is separated by commas. I need each number in the column to be split into it's on column. Is there a way to do this?
Are there always the same number of elements in the list, or is there a maximum value? I'm thinking you would need to add something like this in each of your columns:
=IF(NOT(ISBLANK([Primary Column]@row)), LEFT([Primary Column]@row, FIND(",", [Primary Column]@row) - 1))
*This might look complicated, but it reads "If the Primary Column at this row is not blank, then take all the characters at the beginning of the string until you get to a comma". The result would be A12
=IF(NOT(ISBLANK([Primary Column]@row)), MID([Primary Column]@row, FIND(",", [Primary Column]@row) + 2, 3))
*This one reads "If the Primary Column at this row is not blank, then find the middle section after the first comma, ignore the space, and take the next 3 characters.
This does not provide you with a completed formula, but hopefully provides some ideas about how to get at the data.
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello Smart-Heads! This one might sound trivial, but I am looking for an automation to copy limited amount of information from one row to a new row in the same sheet. The sheet contains initial generic information. Column E can be duplicated across the sheet with unique values from column F, assigned to column E, example:…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.