Why is my copy a row automation duplicating on the new sheet?
I have an automation set to copy a row to another sheet when active turns red where the discharge disposition is one of several choices. It keeps duplicating the copied information, resulting in alot of extra work to clean up the sheet.
Answers
-
Is the automation copying your data to the same sheet? Start by double-checking your sheet choice for where it's copying the data to.
Also, sharing a screenshot of the automation settings could be helpful.
-
Yes it is copying duplicate entries to the same sheet.
-
What I meant, is this sheet the same sheet that its creating duplicates on?
Are you copying the rows to itself? THat is the first place I would look. Make sure the copy to the sheet is set correctly. You may also want to also use the record a date action to prevent this from happening more than once. You could create a row copied date column and set up another action when this fires to create a date in that column. THen set the condition on the same workflow to only fire if the row copied date is empty. This would ensure it would only fire once.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!