Copy row and change a value in a cell by using a list

Hi guys! I need a little help in a formula in my app.
My app is used for my workers. They have to register every job and time in the app and it is uniqe id (email) spesified/adjusted to each user.
Sometimes they are more than one on a job and they all have to register separatly in their apps. Often they are two on a job and they hav asked for a function where they can choose a coworker from a list to spare registering time for the both of them.
Wich formula can i use in the bakground to fix this? Some kind of copy row and edit the copy? all info in the rows must be the same, but their uniqe id must somehow be changed to the coworker choosen from list of coworkers.
Can anyone help?

Best regards
Linda Strand

0 18 1,557
18 REPLIES 18
Top Labels in this Space