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

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    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.

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!