Sending Rows with System Generated columns

Sean Nickell

I'm having an issue sending rows that have system generated columns to other sheets in my workspace. The problem is that I have multiple system generated ID rows across different sub sheets, each ID row is formatted differently, and I want them to all funnel into a master sheet's text/number column. Each time I automate a move row it just creates a new row in my master sheet, and I can't get the ID columns to send to my ID row in the master sheet.

Anyone know how to help me with this?

Paul Newcome

It will continue to create new columns as long as there are new column names, and system generated column names can't be repeated. However...

You could use a formula on the target sheet to pull the data from the other column(s).

Paul Newcome

Can you provide a screenshot with some manually entered "dummy data" that reflects what you are trying to accomplish? I think I understand what you are asking, but I am not sure.

Sean Nickell

Above is the sheet with the rows that I want to export when the box is checked

Here is the sheet they need to be imported to

Here is what the workflow looks like

And here is the issue, it creates a new column altogether, which makes sense because the names are different

But here's what happens when the names are the same.

Is it possible to send system auto-number columns from multiple different sheets to one text/number column in another sheet?

Paul Newcome

It will continue to create new columns as long as there are new column names, and system generated column names can't be repeated. However...

You could use a formula on the target sheet to pull the data from the other column(s).