Bring data from another sheet (Row data)

Great community!

I need help to bring data from another sheet.

If data is input vertically, then I can use countifs or sumifs, etc... but it is horizontally input.

In the picture, I want to bring the number 100 (Purple) to Green square from the Sheet 2 to Sheet 1

, When customer name, product name , Year and Month is same

The Year, Month automatically change (Move to the front column) when time passed, so couldn't use the 'Cell linking' function.

Please help !!!

Find more posts tagged with

Accepted answers

Kevin Smith

Hi,

Thank you for sharing. If the sheets are pretty static other than the data and the most you would do is either add or remove columns, maybe even customers (adding products to customers will require a little more work but not bad), then you really could just use linked cells.

In case you are not sure how that works, you would go to Sample 1 and highlight the cells in the col. you want to be filled from Sample 2. Then right click and select "Link from Cell in Other Sheet..."

Then find the sheet in the window that comes up, this will be in the "Select a data source" tree selection area to the left. When the sheet is selected, highlight the area you want to link to and click on Create a link.

The Sample 1 sheet col. will look like this:

And Sample 2 col will look like this:

Remember the links will always stay with the cell they are linked to so if you do move the col. or insert cols. you are fine, and likewise if you insert a row, you are fine but will need to link the cell in the new row to a new row in the Sample 1 sheet.

If you have a situation where your sheets are changing a lot, I would suggest doing this differently, maybe restructuring your sheets so you can look up the values using index/match but of course that is a lot of work and not needed if this works.

I hope that helps in some way, please let me know if you have other questions or have an issue with doing this.

All comments

Kevin Smith

Can you send an image that includes the headers of both sheets and show a few additional rows/cols. I would like to understand if some rows stay the same, etc. (for example, is the header in S2 the Month 'Apr' and the row below it is always the numerical month '4' if it is in that col? Likewise with S1, what are the headers on that sheet? Also, is Customer 1/Prod 2 under the Cust1/Prod1 and it continues to different Customers and Products.

Someone else might be able to respond faster than I but happy to give this some thought.

Thank you.

jihag

Thank you for your comment

Added link below. I want to bring data from sample 2 to sample 1

sample 2 is manually input and sample 1 brings data of the same year, month, customer, and product

Year and Month from sample 1 is automatically changed when the date passed.

SAMPLE 1 : https://app.smartsheet.com/b/publish?EQBCT=9656f9dfdad748329cb72eb73649b0fb

SAMPLE 2 : https://app.smartsheet.com/b/publish?EQBCT=54ee938696bf4e7cb3558577d2f270b0

Kevin Smith

Hi,

The Sample 1 sheet col. will look like this:

And Sample 2 col will look like this:

I hope that helps in some way, please let me know if you have other questions or have an issue with doing this.

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.