Automation not working - not enough rows?

MindyM

Hello, I'm receiving an error when my automation is trying to run because it's saying there isn't enough rows in the sheet however I only have 4,747 rows in the sheet the data is supposed to move to. How can I fix this?

Pauline J

@MindyM

Hello, Is it possible that the sheet has "empty rows" — rows that might have had data in them, and then the data was deleted? I have found that just removing the content of the cells doesn't actually remove the row — so Smartsheet thinks there are more rows in the sheet. When I right-click and select "Delete Row" the row itself is removed. I hope it's an easy fix for you!

Pauline

Pauline J

@MindyM

Hello, Is it possible that the sheet has "empty rows" — rows that might have had data in them, and then the data was deleted? I have found that just removing the content of the cells doesn't actually remove the row — so Smartsheet thinks there are more rows in the sheet. When I right-click and select "Delete Row" the row itself is removed. I hope it's an easy fix for you!

Pauline

MindyM

Thank you!! That was the problem. I appreciate the tip! :)