How can I get container codes in form entry to different rows in the sheet?

In the form entry, i want people to be able to type multiple container codes by separating them by a semi-colon ";"


Is there a way to make it so that if there are multiple container codes that the different container codes go to multiple rows instead of separating them by columns? I want all the other data to copy to the row as well. I just want to be able to have multiple rows for different container codes instead of columns.

Does this make sense?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!