Copy row when certain criteria are met and edit data within the row
Hello,
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
Answers
-
You can copy the row to another sheet, use formulas in the second sheet to generate a new date, then copy the row from the second sheet back to the first.
-
Ah brilliant, thank you very much!
-
Happy to help. 👍️
-
I have tried this and where I am struggling with this populating the new date - Ideally I want the second sheet to copy the row and add 365 days to the due date but I cannot see any functionality to add to a date in the automation. Is there a workaround? I need the due date to update when copied back to the original sheet so that it is assigned to the next year. Am I missing something?