Copy row when certain criteria are met and edit data within the row

edited 04/25/24 in Smartsheet Basics


I am managing a list of products where our customers often re-order the same product the following year around the same time. I want to copy the product specifics to the bottom of the sheet once it is checked as delivered and add a year to the due date. This will allow us to plan for the product delivery the following year and reach out to the customer accordingly.

I know I can copy the row once certain criteria are met but can I copy and edit the data automatically?

Thank you