Automation not working - not enough rows?
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?
Best Answer
-
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
Answers
-
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
-
Thank you!! That was the problem. I appreciate the tip! :)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives