A workflow has become invalid

Hi, I received an email saying that one of the workflows of a particular sheet has been deactivated.

The action for this workflow is so simple, so when the column in another sheet is changed as "completed" the row is copied and moved to a master sheet. It is important to mention that we have been using this for months and it is the first time I see this error. The master sheet has not changed at all and we still within the limit of rows (9,100 rows as of now)

Can someone help me to correct this error?

Any help is much appreciated!!

Best Answer

  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭
    Answer ✓

    Hi @Xochitl C.

    The limitation you are hitting is due to the overall cell count. With 9100 rows, depending on how many columns you have, you're probably over the limit.

    The most common solution is to create an Archive Sheet off the Master Sheet. Sometimes Archive Sheets by year are set up and other times its more manual and every 6 months or so someone moves a number rows from the Master Sheet to the Archive Sheet.

    I hope that helps.

    Matt

    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner

Answers