control center breaks when adding in new column to spreadsheet

Hi Ya'll. New to SS.

Situation: I'm using Control Center Blueprint to essentially take our intake form for inquiries and then map it to a project plan and update a secondary sheet that shows the mapping.

Complication: In not understanding the sensitivity of sheets, I added a new column to original sheet.

Impact: As a result, when i use control center to map to the sheet, it moves the columns right. Essentially rendering the mapping useless.

Steps to fix: Removed the new column from the original sheet.

Issue is still presented. Any suggestions to fixing?

Find more posts tagged with

Workflows in Smartsheet

Control Center

blueprint

Accepted answers

All comments

Paul Newcome

Are you able to provide some screenshots for context?

jessica7283

jessica7283

it's shifting everything to the right.

Paul Newcome

I still don't know what it looked like before, which column you are adding and where it is supposed to be added, or what you mean by "mapping".

In the Global Update, you can specify where a new column is placed in the sheet. In the "Advanced" section, the blue arrow/line will tell you where wihtin the target sheet the column is going to be placed. You can click and drag that up and down to place it where you want.

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.