Automation Saying Cell Limit, but not at limit

MuellerSIU

I have 62 columns and 7921 rows, meaning I have 491,102 cells, well under the 500K limit. However, I am receiving an error in an automation saying the target sheet has reached its limit. Does anyone know what is causing this?

Michelle Choate 2

How much information do you have in your Source sheet? I believe the automation is looking at 100% of the data in your source sheet, adding up that total amount of cells, then seeing if transferring to the destination sheet would cause it to go over that limit with all of the info from the source.

MuellerSIU

The source sheet is blank. When the source sheet is filled out, it then moves the rows to the destination sheet. So, it could be 1 row, or 40 rows, but the sheet is always blank at first.

MuellerSIU

In other sheets, I can set the destination sheet, and I don't get the error, so I am thinking I may need a support ticket. It doesn't make sense, so I wanted to start here to see if there is some other limit I'm not thinking of.

Kerry St. Thomas

"Well under" is probably a bit inaccurate. From a data integrity perspective I'm thinking that a Move Row automation temporarily duplicates the row - similar to how data is written to an old-guard disk drive. Technologically it could be any number of specific reasons that would cause something to max out when it hits a 98% capacity level. I would recommend you not view the 500K row limit as a stark dropoff (where at 499,999 rows performance is 100% and at 500,000 rows it's 0%), as much as an eventual endpoint that degrades the closer to that 500K mark you get. I'd recommend you implement an archival processes - marking anything past a certain age of created or moved to the Illinois Works sheet for either deletion or to an archive, branching the Move Row automation to individual user sheets, or whatever fits your data structure. Good luck!