Duplicating multiple entries of the same Row based on a cell value

Kelly Hudson

Is there a way to automatically duplicate a row once it is added from a form submission based on a cell value in that row?

Jeff Reisman

The most immediate solution that comes to mind is creating an automation rule to copy the row to another sheet, and then an automation rule on the second sheet that moves the copied row back to the first sheet.

Caveat: If you have formulas in your fields in the first sheet, they won't transfer to the second sheet, only the cell values transfer; so when the copied row moves back to the first sheet, it won't have any formulas.

Sherry Fox

Kelly,

I am faced with the same challenge for my needs. If a specific column is "yes" than the row data (until the Yes) needs top be copied into the next row. I have found information regarding copying into a different sheet, but like you, my needs require copying or moving only to another sheet. I even looked at building my automation from scratch and that was not an option.