Data shuttle adding new rows far below existing rows

I'm having a weird problem with a data shuttle that previously worked flawlessly. I have a sheet which includes about 150 rows of information. I run a weekly data shuttle to add/update rows to the sheet. The data source for the shuttle is an Excel file. New data rows are added to the end of the sheet in the next available row.

Recently, when I run the shuttle new rows are added well below the existing data. This weeks data was deposited at row 2,356. Nothing but blank rows from 150-2,355. I've re-mapped the columns in the shuttle, ensured that the excel file doesn't have any hidden rows and manually forced the shuttle to run. Nothing has helped. The Smartsheet sheet is not formatted with parent/child rows. Any guidance would be most appreciated.

Find more posts tagged with

Data Shuttle

Accepted answers

All comments

Gia Thinh

Hi Susan

There was an accidental edit at the row 2,355 of the sheet, which has caused new rows to be added to the sheet from row 2,356.

Just delete the blank rows from 150-2,355 then everything will be fine for sheet updating in the future.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.