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 !!!
Best Answer
-
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.
Thank you,
Kevin
Happy to help if I can.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)
Answers
-
Hi
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.
Thank you,
Kevin
Happy to help if I can.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)
-
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
-
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.
Thank you,
Kevin
Happy to help if I can.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!