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!!

Find more posts tagged with

Workflows in Smartsheet

Accepted answers

Matt Johnson

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

All comments

Matt Johnson

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.

I hope that helps.

Matt

Xochitl C.

Ok, to give more context and update, I tried to copy and move manually, and I got this message:

May be that's why?

Xochitl C.

https://community.smartsheet.com/discussion/comment/457798#Comment_457798

Thanks @Matt Johnson , yes after I figure out, that's what I did. I appreciate your insights!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.