Is there an issue with Copy Row Automation?

Kingsley Wong

Hi,

I am struggling with an issue (bug?) that doesn't display newly copied data using the copy row work flow function and would like to know if any one has come across this?

We have a sheet with vlookup formula which returns some data from a metrics sheet. In this vlookup formula sheet there is workflow which copies this row of data to a second sheet (daily at a scheduled time). Then using the second sheet we generate a chart.

The problem we have is that, when I look on the second sheet (which should contain a new line of data after 07:00) it only displays the old data even after refreshing... UNTIL I sort the data by ascending/descending. Then the data magically appears?

The activity log does show the workflow has copied data onto the sheet.

Regards,

Kingsley Wong

Andrée Starå

Hi @Kingsley Wong

I hope you're well and safe!

Have a look at the bottom of the sheet if the row comes in there. There might be many empty rows.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Kingsley Wong

Hi @Andrée,

Thank you for the quick response! So to see if that was the case I just modified the copy data workflow to 11:00 and deleted all of the empty rows on that data sheet and formula sheet (leaving only one row of data on formula sheet)

When the copy data workflow triggered, it copied the formula data row underneath the existing set of data which is what we were aiming for. However, it added also 49 additional blank rows?

Slightly confused on why that is the case?

Regards,

Kingsley

Andrée Starå

@Kingsley Wong

Happy to help!

To me, it sounds like the copied workflow also copies the other rows. If you look at the Activity Log, how many rows are copied?

Kingsley Wong

Workflow Query.JPG

Uploaded Feb 11, 202171.11 KB

@Andrée Starå,

I believe the workflow only copied one row, I've taken a snapshot of the activity log.

As you can see I deleted some rows (all empty rows), but then new rows were automatically added again when the workflow triggered.

Regards,

Kingsley

Andrée Starå

@Kingsley Wong

Strange!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots of the workflow + sheets? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Kingsley Wong

Workflow Query2.JPG

Uploaded Feb 11, 2021109.89 KB

Workflow Query3.JPG

Uploaded Feb 11, 202190.89 KB

Workflow Query4.JPG

Uploaded Feb 11, 202193.53 KB

So I have a "Metrics" sheet elsewhere. The workflow "Copy" is in the formula sheet, where it is just a vlookup returning data from metrics sheet. The copy goes to a sheet which stores all the data. A second workflow "Move" is in the database sheet where after 7 days it is archived to a third sheet.

Kingsley Wong

Workflow Query2.JPG

Uploaded Feb 11, 2021109.89 KB

Workflow Query3.JPG

Uploaded Feb 11, 202190.89 KB

Workflow Query4.JPG

Uploaded Feb 11, 202193.53 KB

So I have a metrics sheet else where. The formula sheet has a "Copy" workflow, which copies the row to a sheet which acts as a database. The database sheet also has a workflow "Move" which then archives a row after 7 days.

Andrée Starå

@Kingsley Wong

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)