How to automatically add child rows

Options

I would like to add 4 child rows after each approved row. I understand the indenting would be manual.

Workflow:

User submits the project form and form information resides on sheet A

Approver gets the notification and approves the project

The project row gets automatically copied to Sheet B

Add 4 child rows to the newly copied row on sheet B for every approved project

Tags:

Answers