Cell Linking

Cell links let you pull data from one sheet into another and keep it in sync automatically. 

Keep in mind 

• You can link only cells that contain or previously contained data to a destination sheet. 
• It's not possible to link entire sheets, columns, or rows. 
• Cells can't contain both a hyperlink and a cell link.

Link type overview: inbound and outbound

There are two types of cell links:

• An inbound link in a cell gets its value from a cell in another sheet.
  A cell that contains an inbound link is the destination cell for that link, and the sheet containing the destination cell is the destination sheet. A destination cell can have only one inbound link. 

  Identify destination cells by the light blue arrow on the right side of the cell.
   

• When a cell contains an outbound link, the value in that cell updates a cell in another sheet.
  A cell that contains an outbound link is the source cell for that link, and the sheet containing the source cell is the source sheet. You can link a source cell to multiple destination cells. 

  Identify source cells by the grey arrow in the bottom-right corner of the cell.

To see the sheet name for an inbound or outbound link, select the linked cell.

To visit the sheet value that is linked in from or out to, select the linked cell, hover the mouse over the text that appears, and select the link to the sheet.

To delete an inbound or outbound link, hover the mouse over the information that appears and select delete. 

Create an inbound cell link

To create a cell link, you must have at least Viewer permission to the source sheet and Editor permission to the destination sheet.

1. Open the destination sheet.
2. Select a cell, then select Cell Linking   in the toolbar to display the cell linking form.

3. In the Select a Sheet section on the left side of the form, select the sheet containing the source cell.

   Use the search bar to access your sheet by name.

4. On the right side of the form, select the cell you want to reference and then select Create Link.
   This creates a link from the referenced cell, and a blue arrow appears on the right side of the destination cell.

Keep in mind that currently, when you link a date cell to a text/number cell, Smartsheet converts it to U.S. format (MM/DD/YYYY), regardless of your sheet’s region or Smartsheet settings.

Tips for effectively working with cell links

1. When you create an inbound link, an outbound link is automatically created in the source sheet.
2. You can create up to 500 links from the same source sheet at a time, and a destination sheet can have a total of 500,000 inbound links. 
3. You can select multiple cells to create a link to each one:

• The linked cells in the destination sheet appear in the same order as they do in the source sheet.
• Taking this action overwrites any data currently contained in the destination cells.

4. Cells containing cell links don't trigger actions that change the sheet automatically. This includes formulas that reference another cell via an inbound cell link.
5. If your cell link button is greyed out, check whether the selected cell can accept a link and whether you have the required permission. 

Edit or remove links

The sheet owner and collaborators with Editor or Admin access can edit or remove cell links.

Inbound links

You can edit an inbound link by selecting it twice and picking new source cells from the Cell Linking form.

To remove an inbound link from a cell or group of cells:

1. Select a cell (or pick and drag to highlight a group of cells) that contains an inbound link.

2. Right-click and select Remove Link.

   You can also remove links individually by selecting each cell and choosing the delete link that appears. To see the delete link, hover your mouse over the Link in from or Link out to message. Alternatively, after selecting a cell (or a group of cells) with an inbound link, you can press the Backspace key to remove the links.

Outbound links

You must remove outbound links one at a time. To remove an outbound link:

1. From the sheet that contains the outbound link, select the source cell.
2. Hover over the linked cell to see the delete link.
3. Select the delete link.

Deleting sheet rows that include linked cells impacts the cell links. Deleting a row that includes a source cell creates a broken cell link in the destination sheet. Deleting a row with a linked destination cell removes the link from the source sheet.

Use the paste special feature to create links 

Use Paste Special if you're starting in the source sheet or if you want to create links to the same source cells in multiple destination sheets.

To create a link using the Paste Special feature:

1. Open the source sheet and copy a cell or range of cells (using right-click or the keyboard shortcuts).
2. In the same browser tab, open the destination sheet, select the cell where you want to create the links.
3. Right-click (Mac users can use [Ctrl] + click) and select Paste Special to display the Paste Special form.

4. Select the Link to copied cells option, then select OK. This creates links to the copied cells, starting with the selected cell.

   You can’t create links to cells in empty rows or to cells that were deleted after you copied them. 

5. If necessary, repeat steps 2-3 to create more links to the copied cells in other sheets.

Limitations

Not all cells can accept cell links. The restrictions depend on the column type or your sheet's settings.

Columns that never accept cell links

The attachments and discussions columns don't support cell links, as they are designed for files and comments. 

Cells on Project/Gantt sheets with dependencies enabled

When dependencies are enabled on a Project/Gantt sheet, Smartsheet automatically controls certain cell values. Because of this, you can't create inbound links in the following cells:

• Cells with a column formula.
• Start dates that have a dependency.
• Finish dates.
• Predecessors.
• Parent rollup values (start date, finish date, duration, and % complete).

You can still create links in duration cells and start date cells that don't have a predecessor assigned. When you link a start date, the finish date calculates automatically, and you can add predecessors after the link is in place.

Where you can't edit linked cells

Even if a cell has an inbound link, you can't edit it from the following contexts:

• A published sheet
• An update request
• The Smartsheet mobile or tablet app
• A Report
• An Edit form

To edit a linked cell, open the destination sheet directly in your browser.