Why is this happening all of sudden?

Hi all,

I have had an automation set up (and working fine for quite some time) that copies a row to another sheet and then moves that row to a different sheet (Archive) when "send to Archive" is checked.

As stated, this workflow has been performing perfectly for several months. Nothing in the source or destination sheets has been changed.

Recently, the workflow has become invalid and will not run.

I receive the following error message in the workflow " There are too many cells referenced by formulas in this sheet. Please reduce the number of cells referenced by formulas."

When I attempt bypass the workflow (deactivate workflow) and then manually "Move to Another Sheet" or "Copy to Another Sheet" I get the same error message.

too many cells.jpg

I appreciate any and all suggestions. I am probably overlooking something quite basic...but, this has been functioning perfectly for so long and now that it has suddenly given up the ghost has got me scratching my head...plus...it is Monday ;)

Thanks!

Kyle

Answers

  • Hollie Green
    Hollie Green ✭✭✭✭✭

    It looks like your sheet has gotten too big for smartsheets to handle with formulas. What I have had to do is have my sheet with formulas to actually move rows (not copy) monthly to another sheet. When it moves it it gets rid of formulas and allows the sheet to be bigger than my original sheet with formulas. You will manually have to move some to get rid of the error.

What type of plan are you on? Certain plan types require that a system admin give you permission to access group management.<\/p>


<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":109210,"type":"question","name":"Testing New Form","excerpt":"I have created a form that I would like to format and test before activating. My question is, when I edit a Field in the test form, it is affecting my live source sheet. Is there a way to make these edits on the test form without it changing the column names in the source sheet?","snippet":"I have created a form that I would like to format and test before activating. My question is, when I edit a Field in the test form, it is affecting my live source sheet. Is there…","categoryID":321,"dateInserted":"2023-08-21T17:14:09+00:00","dateUpdated":null,"dateLastComment":"2023-08-22T12:04:11+00:00","insertUserID":161827,"insertUser":{"userID":161827,"name":"shatherill","url":"https:\/\/community.smartsheet.com\/profile\/shatherill","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtcWy2hRy0LQYSOFXXdZEDqqUW55n4FS73mNfbiEhn9zzQ=s96-c","dateLastActive":"2023-08-22T12:16:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-22T12:31:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":38,"score":null,"hot":3385346900,"url":"https:\/\/community.smartsheet.com\/discussion\/109210\/testing-new-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109210\/testing-new-form","format":"Rich","lastPost":{"discussionID":109210,"commentID":391810,"name":"Re: Testing New Form","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391810#Comment_391810","dateInserted":"2023-08-22T12:04:11+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-22T12:31:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-22T11:59:15+00:00","dateAnswered":"2023-08-21T21:58:53+00:00","acceptedAnswers":[{"commentID":391730,"body":"

Yes. The \"Field Name\" is the column name. The \"Field Label\" is just what appears in the form.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":109197,"type":"question","name":"Forms","excerpt":"I created two different forms and the data entered on both of them is saved in the same sheet. How do I get it to save on two separate sheets?","snippet":"I created two different forms and the data entered on both of them is saved in the same sheet. How do I get it to save on two separate sheets?","categoryID":321,"dateInserted":"2023-08-21T14:53:07+00:00","dateUpdated":null,"dateLastComment":"2023-08-21T21:46:32+00:00","insertUserID":165409,"insertUser":{"userID":165409,"name":"mpatton","url":"https:\/\/community.smartsheet.com\/profile\/mpatton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zDPQszzjyv0!iTHSYpyQ8H0!4mIm1J-gpMN","dateLastActive":"2023-08-21T23:16:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-22T12:31:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":28,"score":null,"hot":3385286979,"url":"https:\/\/community.smartsheet.com\/discussion\/109197\/forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109197\/forms","format":"Rich","lastPost":{"discussionID":109197,"commentID":391727,"name":"Re: Forms","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391727#Comment_391727","dateInserted":"2023-08-21T21:46:32+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-22T12:31:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-21T20:23:16+00:00","dateAnswered":"2023-08-21T19:38:23+00:00","acceptedAnswers":[{"commentID":391698,"body":"

You would create the sheet first, then you can click on \"Forms\" in the top right corner of the new sheet to create the form.<\/p>


<\/p>

If you need a bunch of the same columns, You can \"Save as new\" the existing sheet and then just delete whatever you don't need from each sheet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4966,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics