Automation - Copy Row to Top of Slave Sheet and Autogenerate new row number

Hello,

I have two sheets, Quotations and Work Orders. I would like to create an automation that copies a Quotation row to the Work Orders sheet when that row's Status is changed to "Ordered". As I use different Quotation numbers and Sales Order numbers (which are auto generated from form entries in their respective sheets), I want the copied row to appear at the Top of the Work Oder sheet with an auto generated Work Order number. Is this possible? at the moment the row is copied to the bottom of

Tags:

Answers