I have a [email protected] value in the column Zone1 separated by a delimiter which needs to be split into different rows as a list of values similar to column Zone1new. Could i get help on this?
THIS SHEET provides a solution for parsing a comma delimited text string down a column.
Happy to help. 👍️
Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.
Hi Paul, I used the same method but unable to parse the list. Not sure, what went wrong!
Remove the VALUE function form the formulas in the List column.
Great! thanks so much, its working now. I got my solution. Most Appreciated🙏.
@Paul Newcome Hi, I am also trying to parse a list of comma separated names down a column. I had a question about your solution, how are you able to use a circular reference and not get an error in the string column?
@Chandlerw I don't have any circular references. Are you able to pinpoint exactly where the circular reference is coming from?
Hello, I am new to smartsheets and have been looking for a way to split text in a row delimited by a "," into rows in a separate column. Unfortunately the sheet that provides a solution for parsing a comma delimited text string down a column is no longer available. Would you be able to share this sheet again @Paul Newcome ? Thanks so much. Appreciate your help!
©2022. All Rights Reserved Smartsheet Inc.