Applies to

Smartsheet

Capabilities

Who can use this capability

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

Cell links: consolidate or maintain data consistency

使用细胞连接创建一个上卷,凯p track of cross-project date dependencies, or to ensure values stay current across a collection of sheets.

PLANS

  • Smartsheet

Permissions

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

You can only link cells that contain data, 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.

There are two types of cell links:

  • Aninbound linkin 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. Destination cells are designated by a light blue arrow on the right side of the cell.
  • When a cell contains anoutbound 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. A source cell can be linked to multiple destination cells. Source cells are designated by a 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 a value is linked in from or out to, select the linked cell, hover the mouse over the text that appears, and click the link to the sheet.

To delete an inbound or outbound link, hover the mouse over the information that appears and click删除。

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. Click on a cell and then clickCell Linkingin the toolbar to display the cell linking form.

  3. Select the sheet that contains the source cell in theSelect a Sheetsection on the left side of the form.
    Use the search bar if you need to search for the sheet.
  4. On the right side of the form, select the cell you want to reference and then clickCreate Link.
    A link from the referenced cell is created, and a blue arrow appears on the right side of the destination cell.

Tips for effectively working with cell links

When you create an inbound link, an outbound link is created automatically in the source sheet.

You can select multiple cells to create a link to each one:

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

You can create links of up to 500 cells from the same source sheet at a time and can have a total of 500,000 inbound links in a destination sheet.

To prevent infinite approval loops, cells that containcross-sheet formulasorcell linkswill not trigger an automation that automatically changes the sheet (Move Row, Copy Row, Lock Row, Unlock Row, Approval Request). To work around this, consider usingtime-based automationorrecurrenceworkflows.


Edit or remove links

Inbound links

You can edit an inbound link by double-clicking it and selecting new source cells from the Cell Linking form.

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

  1. Click a cell (or click and drag to highlight a group of cells) that contains an inbound link.
  2. Right-click and selectRemove Link.

    Alternatively, you can remove links one at a time by selecting each cell and then clicking the delete link that appears (you'll need to mouse over the "Link in from" or "Link out to" message to see the delete link). Or, press Backspace after clicking on a cell (or a group of cells) with an inbound link to remove the links.

Outbound links

Outbound links must be removed one at a time. To remove an outbound link:

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

Deleting sheet rows that include linked cells will impact the cell links. Deleting a row that includes a source cell will create a broken cell link in the destination sheet. Deleting a row with a linked destination cell will remove the link from the source sheet.


Use the paste special feature to create links (start from the source sheet)

UsePaste Specialif you are starting in the source sheet or if you want to create links to the same source cell(s) 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, click on the cell where you want to create the links, then right-click (Mac users can use [Ctrl] + click) and selectPaste Specialto display thePaste Specialform
  3. Select theLink to copied cellsoption, and then clickOK. Links to the copied cells are created 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.
  4. If necessary, repeat steps 2-3 to create more links to the copied cells in other sheets.

Cell types that don’t allow links

Cell links can't be created in the Attachments or Discussions columns.

If you havedependencies enabled on a Project/Gantt sheet, you can’t create inbound links in the following types of cells on that sheet:

  • Cell with a column formula
  • Finish dates
  • Predecessors
  • Parent rollups (start date, finish date, duration, % complete)
  • Start dates with a dependency

However, you can create links in the duration and start date columns (if no predecessor exists for the row). The finish date will be calculated automatically, and you can add predecessors after creating the link.

Cells that have inbound links also can’t be edited in the following contexts:

  • From a published sheet
  • From an update request
  • From the Smartsheet mobile app
  • From the Smartsheet tablet app
  • From a Report
  • From the Edit form
Was this article helpful?
Yes No