Copy/Paste Cell linking

kmottershead · 01/21/19

I am trying to use the paste special option to link a cell but the "Links to copied cells" radio button is grayed out. I've tried this on multiple sheets, and it still will not give me the option.

Andrée Starå · 01/22/19

Hi,

Are you staying on the same tab?

There seems to be an issue at the moment to copy outside the same tab.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

cmaher · 03/14/19

I'm actually having a similar issue. I've looked around the community, and what I want to do seems to be possible, but I am getting the option to special paste completely greyed out.

Scenario:

I have two sheets (one project, the other is either a task list of just a grid). I am copying a date that is in the task list/grid, and then going back to my project and attempting to Paste Special in to a start date. When I do this, the Paste Special option is greyed out (see attached). Both cells are configured as "dates".

I have no problems going through the Link from Cell in Other Sheet option from my project (you can see that I have linked for other dates using this method in the screenshot).

I am doing this within different tabs within the same Google Chrome window.

Any ideas?

Paste Error.jpg

Andrée Starå · 03/14/19

Hi,

Try to do it inside the same tab and see if that works?

Best,

Andrée

cmaher · 03/14/19

Hi Andree,

I know that's how Smartsheet used to work, but I'm not sure I know how to open a new tab within Smartsheet (within the same Google Chrome tab).

Ciaran

Andrée Starå · 03/15/19

Hi Ciaran,

Unfortunately, you must open the other sheet in the same tab by either going back in the browser (if you were in that sheet previously) or selecting the sheet in the left panel in Smartsheet. The important thing is that you need to keep the sheets in the same tab and not open in another tab.

Did it work?

Have a fantastic weekend!

Best,

Andrée

Erin Cartwright · 12/10/20

It's *REALLY* annoying that this option is not working using different tabs.

Fabien Soullier · 03/24/21

Does anyone have a link to where this bug has been reported? This is very annoying. Thanks

Abel · 03/30/22

I still experience this issue. Is this solved already?

cvallee · 04/07/22

It does not seem to be working even in the same sheet. Trying to copy the link in the cell on line 45 to line 48 and the "links to copied cells is grayed out".

DanPihlaja · 09/20/22

Andrée Starå

Jan 22, 2019

Hi,

Are you staying on the same tab?

There seems to be an issue at the moment to copy outside the same tab.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

There seems to be an issue "at the moment"? Your wording implies that this is NOT intended behavior, which would mean that it is a bug or similar.

Wow.... That was 3 years ago and the issue is still present.

So....what is smartsheet doing to address the issue? Paying customers want to know.....

Do they even read these?

Smartsheet Basics

Smartsheet Basics

Copy/Paste Cell linking

Answers

Quick Links

Categories

Trending in Smartsheet Basics

Has anyone tried to create a trivia game using Smartsheet?

What's the maximum number of rows in a sheet ? Is there any limitation on the number of columns ?

Sharing Permission; Shared Sheet Management for Unlicensed User/Free Collaborator