I have read several posts that suggests that this is not currently an option.
I have a sheet which contains a list of evaluations. Sometimes we have to complete a second, or even third evaluation of the same person. Each row represents a person and their evaluation. If we have to do a second evaluation then much of the data in the row is unchanged. So we want to duplicate that row in the same sheet and update a few fields.
So my staff receives a report to process, and use a Report that pulls the pending evaluations. They enter some values. I want them to enter a value (a checkbox in a column named "Duplicate Row"). I want that checkbox to trigger an automation that Duplicates the row in the same sheet, puts it at the bottom, and then changes a few values - specifically unmarking the "Duplicate Row" box.
Is there a work around that does not involve programming? Is there a way to create an automation maybe opens a "Temp Sheet" and then moves the row back to the original sheet? Maybe by triggering a second automation? I could have them do it in the original sheet with a simple Copy and Paste, but that sheet contains 1000s of rows. Also the report allows me to filter out the unneeded columns and focus on this task.