Copyrow Automation Not Working When It Said It Did

Ryan Holguin
Ryan Holguin ✭✭✭✭
edited 11/14/24 in Smartsheet Basics

Hello All,

Can you all help me understand why my CopyRow Automation didn't work even though the Activity Log said it ran?

My thought is because changes were made to the ran within a minute after saving it initially preventing it from running even though the system said it did.

I can send a snippet of the workflow if you need to see that as well.

Tags:

Answers

  • kowal
    kowal Overachievers Alumni

    hello @Ryan Holguin,

    by saying it did not work you meant the row was not copied to another sheet?

    did you scroll down in the destination sheet to check if the row is not somewhere in the deep bottom?

    I know it's silly question but it happened to me as well sometimes (like while filling the form or copying/moving rows) that in the destination sheet it's being copied to line 100 etc. because there was already some data in line 99 and the text was just removed not entire row.

    Let me know if this works.

    Tomasz Kowalski

    The Real Smartsheet Enthusiast

    Is there anything else we can help you with? - book your time!

    MASA Consult - Your Aligned Smartsheet Partner

    Find us on LinkedIn!

  • Ryan Holguin
    Ryan Holguin ✭✭✭✭

    @kowal - Yes, I checked the destination sheet and checked the activity log for around the same time and do not see it was never added or made it on the sheet.

  • kowal
    kowal Overachievers Alumni

    @Ryan H

    another silly question of mine but I guess we need to go through root troubleshooting session now :)

    When the rows are copied or moved to another sheet the sheet is to be chosen in a very limited way (only by name - no structure in the folders etc.) can you confirm that you have only one destination sheet with such name and there is no chance that the destination name could be another sheet that you are checking?

    Tomasz Kowalski

    The Real Smartsheet Enthusiast

    Is there anything else we can help you with? - book your time!

    MASA Consult - Your Aligned Smartsheet Partner

    Find us on LinkedIn!

  • Ryan Holguin
    Ryan Holguin ✭✭✭✭

    @kowal - It is only one destination sheet. Here is a snippet of the workflow. It has to meet conditions before the CopyRow happens:

    A few things happen in this automation: single select dropdown option triggers it, conditions of field not blank are met, CopyRow happens, Email Confirmation is sent to requester, then a sent date is logged.

  • kowal
    kowal Overachievers Alumni
    edited 11/14/24

    is it possible for you to disable this workflow temporarily.

    Create a copy of it - remove all those 7 conditions and check (without any conditions) that the row is copied?

    it could be that actually copying works pretty well but something in conditions is stopping it.

    or only this one action of copying is skipped but the date is recorded and email is sent?

    Tomasz Kowalski

    The Real Smartsheet Enthusiast

    Is there anything else we can help you with? - book your time!

    MASA Consult - Your Aligned Smartsheet Partner

    Find us on LinkedIn!

  • Ryan Holguin
    Ryan Holguin ✭✭✭✭

    Well, this only happens on occasion when the automation doesn't trigger, even though the user did everything correctly when I look into it.

    None of the other actions happened either. No email sent or date recorded.