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?
-
I figured this out, I added a column in my original sheet called "Carry due date" which was Due date +365. When rows are copied through automation, the formulae do not also copy, so when the rows copied to the helper sheet, "Carry due date" was no longer a formula. In the helper sheet, I made the "Due date" = "Carry due date" and then copied this back into the original sheet. As none of the formulae copied back, the new due date showed with an extra 365 days.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives