Separating data into separate rows, under the original an auto generated column number


My department has an existing SmartSheet, to track travel. This sheet autogenerates a number based off of a form submitted for approval. The issue is that in the form staff are able to list ALL travelers for the trip, which results in the names being included in one cell. However, I need to be able to have each traveler in their own row to be able to track their travel individually. We also want them associated with the original approved trip number. Is there a way to accomplish this? I have tried adding rows, but it creates a new travel number.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!