Cell Linking Across Sheets

In our workspaces, Linking cells across sheets has been a bit cumbersome using the existing option in Smartsheets (please refer to the attachment).

It would be great if Smartsheet can introduce a “paste special” option where I can copy the content of a particular cell (or cells) from one sheet and paste it as a link into another sheet directly (like how it works in excel).

This will save us a lot of time and effort.

Link Sheets.png

Sign in to vote!

Find more posts tagged with

Available Now!

Comments

Genevieve P.

Hi @sydga_29

This is currently available! You'll just need to navigate between the two sheets within the same Browser tab. Then you can use Paste Special to paste in cells as cell-links.

Here's more information - Create cell links, copy formula results, or formatting

Cheers,

Genevieve

patty perless

Hi @Genevieve P.

Do you happen to know how to copy the link into multiple cells in the destination sheet? I have quite a few rows that need the same link so the when the source link is updated all the rows in the destination sheet will be updated automatically. Thanks for any guidance! Patty

Genevieve P.

Hi @patty perless

Working in the same browser tab, you can copy the original cell, then paste it multiple times into the destination sheet!

It will require you to "paste special" into each cell individually, but once the cell from the first sheet is copied, that link will be remembered until you copy something else.

Cheers,
Genevieve

Quick Links

Trending ideas

Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…