2-Way Cell-Linking

I frequently link cells because it is very convenient. Could it be possible to enhance this, so that one doesn't have to use "Go To Sheet" in order to update the value? In other words, can we have 2-way linkage, so that if it's updated in either place, then the value has been updated? I constantly have to go to source sheets to update linked cells, depending on the situation, and it would reduce a lot of navigation time spent using "Go To Sheet" and hunting down the cell to update.

Find more posts tagged with

Cell linking

Enhancement Request

Comments

Paul Newcome

Unfortunately it creates a "Circular Reference" Error. I can see how this would be useful though.

j_hyung

This is a great idea.. If i want only one-way linking, i can use a classic cell reference..

Shaine Greenwood

Hi everyone—

We currently don't have this type of cell-linking functionality available in Smartsheet. When you have a moment, please submit a Product Enhancement Request using the form under Quick links to the right of the Community site to let our Product team know that you'd like to see this feature added to Smartsheet.

When you submit the request, please specify the behavior that you would expect to see from this type of 2-way cell link. Would you want the latest change to any of the sheets to be reflected? etc.

In the mean time, you might consider creating a cell link OUT from one of your sheets over to your TWO sheets. That way, you'll only need to change the cell on your one sheet for it to be reflected on both other sheets.

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Can we run the request for update to include all the rows that applied to one condition?
We want to know if it is possible to send request for update in one email, but with multiple rows at the same time. For example, staff A has 4 open referrals, I want to send one request for update automatically to them where they will receive only one email without having to overload them daily with all the open referrals…