Sending Rows with System Generated columns
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?
Best Answer
-
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).
Answers
-
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.
-
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?
-
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).
