How to divide single request with multiple contacts to individual requests.


Does anyone know how to take a single line, with a single multi-select cell, and have that line parse/delineate/divide in to individual lines, either through a formula or an automation?

Scenario: we are receiving schedule block request for team, and multiple people may be on the block request, therefore we have multiple names on a single sheet line; the scheduling team wants to confirm they have blocked each individual person by each person having their own line on the sheet.

Is there away to go from the top line to the individual 3 lines, either on another sheet or through a formula?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!