To delete an inbound or outbound link, hover the mouse over the information that appears and click the delete link. To visit the sheet that a value is linked in from our out to, select the linked cell, hover the mouse over the text that appears, and click the link to the sheet:
To see the sheet name for an inbound or outbound link, select the linked cell: Source cells are designated by a grey arrow in the bottom-right corner of the cell.
When a cell contains an outbound link, the value in that cell updates a cell in another sheet.Ī 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. Destination cells are designated by a light blue arrow on the right side of the cell. A destination cell can have only one inbound link. An inbound link in a cell gets its value from a cell in another sheet.Ī cell that contains an inbound link is the destination cell for that link, and the sheet containing the destination cell is the destination sheet. To check your links, verify the data at the destination. A missing indicator does not mean your link is inactive. You can use more than 2,000 links, but you will only see 2,000 indicators. Smartsheet displays 2,000 of these indicators for outbound links, max. Typically, when you link a cell, you'll see an indicator on the right edge of the cell. Cells can't contain both a hyperlink and a cell link. Only cells that contain data, or that previously contained data, can be linked to a destination sheet. It's not possible to link entire sheets, columns, or rows. Use cell linking to create a roll-up sheet, to keep track of cross-project date dependencies, or to ensure that values stay current across a collection of sheets. 
Cell linking is useful when you want to consolidate information from multiple sheets.
0 kommentar(er)
