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
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives