Cell Linking
I have a database and a sheet linked to it which is fetching few of the database columns.
Whenever I sort data in the database the data in the other sheet (linked sheet) is not getting sorted.
Any suggest how i can keep the data in the linked sheet intact?
Best Answer
-
Ok. And how exactly is the data in [Primary Column]@row being populated?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Are you currently using cell links or formulas?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul I am using Cell linking.
-
Do you have a column on both sheets that contains unique data per row?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I have a column which has auto generated Number/ID. is that you are asking about?
-
Yes. That can work. You would need to make sure that this column matches on both sheets, and then you can use formulas with cross sheet references to pull the data.
=INDEX({Column to pull from other sheet}, MATCH([Auto-Number Column]@row, {Other Sheet Auto-Number Column}, 0))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I am not pulling all the columns from the source datasheet, hence will this work for it?
-
Yes. You would only need to specify which columns you wanted to pull. You would have a series of formulas similar to above. One for each column you want.
=INDEX({1st column you want to pull from other sheet}, MATCH([Auto-Number Column]@row, {Other Sheet Auto-Number Column}, 0))
=INDEX({2nd column you want to pull from other sheet}, MATCH([Auto-Number Column]@row, {Other Sheet Auto-Number Column}, 0))
=INDEX({3rd column you want to pull from other sheet}, MATCH([Auto-Number Column]@row, {Other Sheet Auto-Number Column}, 0))
So on and so forth only selecting whichever columns you want.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Paul I tried it but it is throwing #NOMATCH error I am using the following
=INDEX({Word Order #}, MATCH([Primary Column]@row, {Document Name AC Power}, 0))
-
Paul also NOE that I am linking the Primary column to the Work Order # first and then using it in formula.
-
What is in this range? {Document Name AC Power}
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
It is the name of the column/range as {Other Sheet Auto-Number Column},
-
My mistake Paul, it should have been the following way.
=INDEX({Document Name AC Power}, MATCH([Primary Column]@row, {Word Order #}, 0))
-
Ok. And how exactly is the data in [Primary Column]@row being populated?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives