Smartsheet skips rows with new form entries
Hi, I've sporadically experienced that when new form entry is added to the bottom of the sheet, it doesn't go right below the previous one, it skips say 5 or 6 rows and then gets added. This doesn't happen when the new form entry is added to the top of the sheet. This causes the sheet formulas not to carry over to the new entry since it's not added right below.
Is this a known issue?
Thanks, James
Answers
-
The form entry will populate the first UNUSED row. Not necessarily the first EMPTY row.
If there was data in the row before that was deleted, then the row is still considered used and will not be populated by a form. You would need to delete the row itself instead of just deleting the data from the cells.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome Never knew that before, thanks for your quick reply! Is there a reason why smartsheet is designed that way?
-
It goes to the next unused row so that it does not overwrite any data. That is much easier than having to inspect every single column on a row by row basis looking for one that has no data in it. Doing it that way could have forms inserting new rows in the middle of a sheet if data was deleted from a row or opens up room for more issues/bugs by missing data.
It is just easier and much safer to look for an unused row.
At least that is my assumption. I can't say for sure that's what it is, but it seems like a pretty safe assumption to me.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives