Use one row to create multiple new rows in a sheet
I'm trying to see if there is a way to use automation to create multiple new rows in a sheet when a row is added through a form.
My thought process was that I could setup an automation on the sheet that would move the row to another sheet and then I could have automations in the second sheet that would update a couple of fields and then move the row back to the first sheet. Then when the "updated" row got moved back to the original sheet, an automation on that sheet would copy that row back to the second sheet and additional automations in the second sheet would update the necessary fields to their new values and then move the row back to the original sheet, thereby creating a 2nd new row in that sheet. These back-and-forth process would continue until all of the additional rows were created in the original sheet. There should be no rows remaining in the second sheet because they were always moved back to the original sheet.
When I test this, the automation in the first sheet successfully moves the row to the second sheet and the first automation in the second sheet successfully updates a field in the row. But when the next automation in the second sheet is triggered to update another field in the row, it seems to be delayed long enough so that the next automation that is designed to move the row back to the original sheet never gets triggered. The I get a "workflow has become invalid" email from Smartsheet for the next automation that was designed to be triggered when the original sheet automation copied the "new" row back over to the second sheet in order to begin the process to "create" the next new row that I need in the original sheet.
I realize that is probably confusing to follow but hopefully it makes sense to someone and they will have some suggestions as to what I might be doing wrong - or tell me there is absolutely no way to do this in Smartsheet.