Column Linking?

How can I get info entered and added from one sheet copied to another on an ongoing basis?

For this example if the below address was entered today, how do I get the City and State values to be copied to the "Test 1 Main Sheet"?

I know I can do cell linking however I'm looking that if tomorrow I add a new row how does that city and state get copied to the other sheet, aside from linking cells each time a new row is added?

Find more posts tagged with

Accepted answers

All comments

kowal

Hi,

The cell - linking in Smartsheet is not dynamic.

You can link at once like 10-20 rows but if you add new row that was not linked first it will not copy the data.

I know that this is a basic functionality of Bridge but it needs to be purchased.

Would VLOOKUP or Index/Match formula work for you?

ejacksonBPT

I do not know what VLOOKUP or Index/Match formula are so will need to research those. Thank you,

Michelle Choate 2

The other option is to set an automation that copies the row to the other sheet, and then hide any columns that you do not need that come over, however this is not dynamic and if you need to update anything, it will copy the row again as new.

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.