When copying rows from Sheet1 to Sheet2 the Unique ID overlaps the value in the destination
I have a master sheet that holds contracts and a secondary sheet that manages Invoice orders. When a contract is approved a workflow then copies the contract row to the invoice orders as many times as invoice should be produces in the particular contract.
I originally thought of using the auto number column to differentiate one invoice from the rest.
The problem is that since I also use auto number column in the contract sheet and it is a system column the contract sheet ID is the copied to all the invoice orders I create.
Does anybody can think of another solution? or How can I differentiate "n" identical rows created at the same time through a workflow copy command?
Help Article Resources
Check out the Formula Handbook template!