Why does Smartsheet add empty rows to sheets? Can this be disabled?

If I delete empty rows on a sheet, after saving and reloading, Smartsheet will add 10 empty rows to the bottom of the sheet. Example: My 66 rows becomes 76 rows (10 empty). 50 rows becomes 60 rows (10 empty).

When I use a "Copy Row" automation, Smartsheet adds enough empty rows to ensure the destination sheet has at least 50 rows.

Is this something I can turn off?

Find more posts tagged with

row

Accepted answers

kowal

hi @NeilKY,

nope that's by default smartsheet always add those extra 10 rows.

Someotimes it's annoying if you want to countif by blank cells but there is workaround for that.

All comments

kowal

hi @NeilKY,

nope that's by default smartsheet always add those extra 10 rows.

Someotimes it's annoying if you want to countif by blank cells but there is workaround for that.

NeilKY

Hmph… thanks :)

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.