Multi Select Drop Down Parsed to Separate Rows in a new sheet

Options

I have a column in one sheet that is a multi-select drop down for ease of population for the user which I need parsed out in another sheet.

The user will fill out this template (sheet 1) first to choose the risks associated with each item:

The data in sheet 1 is linked to sheet 2 via cell linking, but I need the risks to link to this sheet in separate rows, ideally indented underneath the item description. There are additional columns specific to each risk that needs to be populated, which is why there is the need to copy over in a new sheet.

Any idea how this can be done?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!