Copy row from one sheet to other only when a row is newly added to one sheet

Question

Hi,

I have this Main Sheet and Sub sheet and have data in both the sheets.

If i add a new row to Sub sheet only then, the row should copy to Main sheet. I have tried using Automation and condition used was (When row is added or changed). But i am facing issue that whenever any data is changed the row is copied as many times the data is changed.

I want it to copy only one and only when the row is newly added

Is there any way to achieve this?

AdamSYNH · Accepted Answer

Hi @Tasneem

Try using a helper column on the end of your row in each sheet, set the column type as checkbox. Add a condition where your checkbox column is not checked and set the last step of your automated flow to Change cell value. Select your checkbox column and set the step to change the value to checked.