Automation to Move Rows from Sheet to Sheet is not working

Aaron D.Aaron D.
edited 12/09/19 in Using Smartsheet
11/27/19 Edited 12/09/19

I have my sheets set up where each row represents a project and respective information.  I have a column in each that can be changed to a department heading and I have an automation set up to make it so that when changed the rows move to the department sheet selected in the drop down box.

Now, I have 6 sheets with basically the exact same Automation set up.  However, one of the sheets the Automation will not work.  I've deleted the automation twice and reset it up but nothing seems to work on this one sheet.  So basically when a project row gets moved to this department it gets stuck there.

All of the other sheets work just fine with the same automation.  And each she was a duplicate of the original sheet set up so settings should all be the same.

Can anyone give any advice as to what I might be missing or what the next best thing to do is?

Comments

  • Nevermind... got it to work.  Just a fluke I guess.  I've done this before but I changed it to the current department, saved it, exited out of the sheet, came back to the sheet, changed the rows to the departments I needed them moved to and then then hit save.  For some reason it wouldn't work before but it worked this time.

  • Mike WildayMike Wilday ✭✭✭✭✭

    Glad you got it figured out. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Glad you got it working and thanks for letting us know!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.