Is there away to take the values in a Join/Collect cell and separating it in to different columns.

Jacob Mizer
Jacob Mizer ✭✭✭
edited 09/08/22 in Formulas and Functions

I have a join/distinct/collect Char(10), and some of the Cells pull data 1, and 2. Is the formula to separate that data into separate columns? So 1 would go to the 1st column, and 2 would go into the second column.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!