Copy and duplicate Rows based on value in cell

BrandonDean

Hi there,

I have the issue where a user is attempting to duplicate the cell value within a sheet, based on a trigger, and a quantity.

For example:

Form intake produces a row with the values

Column: Status = "Requested"

Column: Quantity = "3"

Column: CODE = "ABC"

I would like when the Column: Status changes to "Published", it creates an automation to create "3" new rows within another sheet, all with the CODE ABC.

In theory, I would like to expand on this as well, so that not only the CODE will be created as a unique line item based on the Quantity, but other column values can be taken as well.

How can I go about doing so?

Andrée Starå

Copy and duplicate Rows based on value in cell

BrandonDean

Jun 18, 2024

Hi there,

I have the issue where a user is attempting to duplicate the cell value within a sheet, based on a trigger, and a quantity.

For example:

Form intake produces a row with the values

Column: Status = "Requested"

Column: Quantity = "3"

Column: CODE = "ABC"

I would like when the Column: Status changes to "Published", it creates an automation to create "3" new rows within another sheet, all with the CODE ABC.

In theory, I would like to expand on this as well, so that not only the CODE will be created as a unique line item based on the Quantity, but other column values can be taken as well.

How can I go about doing so?

---

View Post

Hi,

I hope you're well and safe!

I've developed some advanced similar client solutions, so it's possible.

Can you share some screenshots? (Please delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

BrandonDean