Adding rows in existing sheet if multiple selections in a column exist
I previously have been searching for a workflow which does the following:
I'd like to achieve within one sheet that as soon as multiple assignees are selected from the respective dropdown list, one or more rows are automatically created below, which copies the content of the above row and splits the multiple assignees so that only one assignee is selected in a row at a time.
For example: If three assignees are assigned to a task (one row), three further rows should be created underneath that specific row. Each of these rows contains the above content, but there is only one assignee in the Assignments column.
Thanks everyone. Every answer is highly appreciated!
Help Article Resources
Check out the Formula Handbook template!