Move Row automation stops working when there is a row deleted from the sheet

We have put a condition where one of the column has a dropdown change, then move the entire row to a different sheet. However, we see that the Automation had stopped working and while performing a troubleshooting exercise, we found that when a user deletes any rows from that sheet where the automation lies, the workflow automation stops working and we have to Edit the move row automation and save it again to activate it again. Very Strange!!

Tags:

Answers

  • Hollie Green
    Hollie Green Community Champion

    It makes sense as the row is no longer there to move and the dropdown did change. A work around would be to change the dropdown maybe add an option for Delete and when it is moved to the other sheet delete it from there instead of the source sheet.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!