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


  • Paul Newcome
    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.

  • 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?