Can I copy cells to another sheet without creating duplicates?
Hi everyone,
I'm looking for some help with automation.
STEP 1: I want to copy row data from one sheet ("Sheet A" for simplicity) to another sheet ("Sheet B") when a status column is changed to green.
STEP 2: I ALSO want to copy row data from "Sheet A" to "Sheet B" when an attachment is added.
By nature, STEP 2 will happen AFTER STEP 1 has been completed, and row data has already been copied to "Sheet B."
I have both automations built; however, this creates duplicate entries in "Sheet B."
Is there a way to complete STEP 2 without creating a duplicate entry? Can I somehow copy the attachment to "Sheet B" and tie it to the existing row that has already been copied over?
Answers
-
A work around for this Is creating a flag that removes the original copy from sheet b to a "Trash Sheet" when the new copy is added. To accomplish this Use a unique identifier in sheet A. When it gets copied to sheet B. You can do a flag using this formula.
IF(Created@row = Max(Collect(Created:Created,[Unique ID]:[Unique ID],=[Unique ID]@row)),1,0)
Then create a work flow when rows are added or changed when "Flag column" changes to any Value. A Condition of "Flag Column" is not equal to 1. Move Rows to what ever the "Trash Sheet" Is. See Ex.
Just be sure to empty out the trash sheet every so often.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
@Mark Poole Using your formula above, I am getting 0s for all rows as they are the same date but different time. Is there a way to include looking at the time?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 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