Move Automation seems to be timing out or conflict

I have a move automation triggered from a cell update. There are currently about 900 records that I would like to move to a separate worksheet. The worksheet contains about 170 columns that would be moved. There are multiple people in the worksheet throughout the day. Additionally, there are other automations launching based on other criteria.

It seems that if I select a large of records, i.e. 100 and click save the automation is not activating. The records do not seem to move even after a period of time. Could it be that automations are bumping into each other as other users are working in the worksheet? Even though, the records I am working on would not be updated by anyone else.

It does seem that if I select a smaller set, i.e. 10 and turn the trigger on and off, eventually the automation will move the records.

paul e. reeves

Principal Business Analyst

HMH

Tags:

Best Answer

  • StevenBlackburnMBA
    StevenBlackburnMBA ✭✭✭✭✭
    Answer ✓

    Do both sheet columns match? Is there a way to perform your moves without such large batch movements, or a way to set up your sheet column moves nightly based on any other triggers?


    Question 2: Do both worksheets match? Are your teams allowed to edit unlocked columns? Some of this could affect things but may ultimately matter on the framework of the set up.

    Certifications:

    -Smartsheet 2023 Core Product Certification

    -Smartsheet 2023 System Administrator Certification

Answers

  • StevenBlackburnMBA
    StevenBlackburnMBA ✭✭✭✭✭
    Answer ✓

    Do both sheet columns match? Is there a way to perform your moves without such large batch movements, or a way to set up your sheet column moves nightly based on any other triggers?


    Question 2: Do both worksheets match? Are your teams allowed to edit unlocked columns? Some of this could affect things but may ultimately matter on the framework of the set up.

    Certifications:

    -Smartsheet 2023 Core Product Certification

    -Smartsheet 2023 System Administrator Certification

  • Paul Reeves
    Paul Reeves Overachievers

    Steven - Thank you

    paul e. reeves

    Principal Business Analyst

    HMH

  • StevenBlackburnMBA
    StevenBlackburnMBA ✭✭✭✭✭

    @Paul Reeves - you’re welcome! Am glad I could help!

    Certifications:

    -Smartsheet 2023 Core Product Certification

    -Smartsheet 2023 System Administrator Certification