I have an automation to copy a row to a new sheet when a date changes. It is no longer working

Cindy Hoyle

I added a new column to the To sheet that doesn't exist on the From sheet so I am wondering if this could be the cause of the automation not working and if so, if I add it to the From sheet is that enough to get it working again.

Paul Newcome

Target and Source sheets do not have to be an exact match. The target does require all of the source sheet columns, but the copy/move row automation will automatically create those columns if needed. You can have additional columns on the target sheet.

Are there any error messages anywhere to include in the automation builder?

kowal

hi @Cindy Hoyle,

did you make the test on by forcing the workflow?

Cindy Hoyle

I didn't force the automation I noticed that dates had changed in the source sheet and there were no new rows added to the log sheet. My question is does the source and the log sheet have to have the exact same columns in order for the automation to work?

Paul Newcome

Target and Source sheets do not have to be an exact match. The target does require all of the source sheet columns, but the copy/move row automation will automatically create those columns if needed. You can have additional columns on the target sheet.

Are there any error messages anywhere to include in the automation builder?

Cindy Hoyle

Thank you! I'll dig in and see if I can figure out why it stopped copying the rows to the target sheet.