Automated Workflow - Mutiple sheets to one sheet

I have an automated workflow set up on multiple sheets to move rows to one sheet when an action is triggered. I've noticed it only works on one sheet. Does that automation only work on one sheet or is there a way to have multiple sheets move rows to one sheet?

Thanks!

Answers

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭

    You can do this, but you'll still have technical limitation of 400 columns on a sheet. When you move a row, it moves all columns with it, including any hidden/column formulas. So if your target sheet would surpass the 400 column limit with a move row automation, it prevents the move row automation from completing. Also check to make sure that you don't have any fields on the target sheet with the same name as a system column of the source sheet, or you'll see this error in your automation editor.

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner

  • Here is the automation I have set up in each sheet but only one sheet is actually working. Any reason why only one sheets automation would be working?