Copying row from one sheet to another AND creating a new row if specific field is duplicated

Nataly Allimonos

Hi team!

Hoping you all can help think through the workflow on this one.

We have an intake form that gets filled out. It's very logic heavy as multiple teams are filling this form out to request different services. The driving force between this form's sheet and another "main sheet" is one unique identifier.

In a very simple use case, a form gets filled out, the IDs then get matched via Data Shuttle, and the data gets copied over to the Main Sheet.

The issue comes in when we have multiple requests with the same ID come in asking for a "one-time" service. Ideally, if the ID already exists and data is already filled out for that row, we would like to somehow get that data transferred over as a competely new row and we can create a unique "project ID" and treat it as an individual project.

Is this somehow doable? Would this mean we create a new data shuttle to add rows if specific criteria are met? Unsure how to proceed here. Thank you!

Paul Newcome

I would suggest an auto-number column and then use that as your unique ID.

Nataly Allimonos

@Paul Newcome - Maybe you might know?

Paul Newcome

I would suggest an auto-number column and then use that as your unique ID.

Nataly Allimonos

@Paul Newcome - This worked really well! Got creative a bit, but it works :D Thank you!

Paul Newcome

Happy to help. 👍️