Celling Linking-Multiple rows

I need to link about 50 cells in my Inventory sheet to the SAME cell in my Inventory Price sheet. Can I do that as a group? I tried selecting all the cells in my Inventory sheet, then selected the linking option, navigate to the Inventory Price Sheet and select the cell I need linked to ALL 50 cells. Using this process it only populates the first cell in my range.

Any thoughts?

Find more posts tagged with

IT & Operations

Cell linking

Comments

L_123

You cannot do this with cell linking. You need to instead use a column reference and return the indexed range.

=index({Column Reference from other sheet},1)

Will return the first value in the column. you can either manually type 1 - 50 in each cell to reference each of the returns, or if you start at the top of your page you can do something like

=index({Column Reference from other sheet},1+count([Current Column]$1:[CurrentColumn]1))

in the second cell then drag it down.

Paul Newcome

You can cell link multiple cells at the same time so long as both groupings are of the same size (and shape). For example. If you want to cell link 50 cells down a row, you would select those 50 cells, link from other cell, then select the other 50 cells. They would have to be 50 cells down a single row for that to work though. If you are linking a 3 x 4 grid, highlight the area, link from other cell, then select a 3 x 4 grid on the other sheet. If the row and column counts don't match up it won't work.

From what it sounds like though... You are wanting to combine the data from 50 cells into 1 cell in which case you would use a JOIN function and reference another sheet.

StephanieR

Hi Paul,

I'm so sorry about the VERY tardy delay in responding. Thank you for the input. I always appreciate learning about new functions. I normally have very basic sheets, but have been forced to go to the next SmartSheet level!

Hope C.

In my case, I have a contact list sheet (with contact details), and a project list sheet that only includes contacts' names. I want to be able to link a contact name on the project sheet to the contact name on the contact sheet so I don't have list the contact's details on every project they are associated with. This contact is not a contributor and does not have a SS account, so I don't want to "assign" them to the cells. By linking the two sheets, it reduces duplicity in listing the contacts information every time their name comes up on a project. And their contact information stays accurate because it is only listed once on the contact sheet. I ran into a problem today where I could not multi-select cells on my project sheet and link to the same contact on the contact list sheet. Is there another solution I should consider?

Sign in to join the conversation!

Quick Links

Trending discussions

Dashboard Adding Widgets Spontaneously
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…