Cell Linking not working

Andy.Mott

Good Afternoon,

I have a report which collates all monthly figures from each Months Tab, and links them into a Detailed Yearly Report for my figures. This is starting from 2018, but ive got down to March 2019 and now the Linking doesn't appear to work. No matter how I do it, the link doesn't show inside my column. 

Is there something stopping this? are you only allowed a certain amount of links per sheet?

Paul Newcome

I cannot remember exactly what the limits are, but there are most definitely limits to how many cells can be linked from other sheets. However, it really doesn't look like you would have hit those limits already. Are you using a formula or directly linking to another sheet?

Andrée Starå

Hi Andy,

I agree with Paul, and if you've had reached any limit, there should be an error message.

More info:

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

https://help.smartsheet.com/articles/861579-cell-linking

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andy.Mott

Hi,

It helps to know I can do upto 500 Cell Links, but the Cell Linking I am doing when clicking on the Paperclip in the Toolbar is not working on my sheet. 

Paul, 

What is the formula to link Cells from different Sheets?

Andrée Starå

Happy to help!

What happens when you click on the Paperclip? What browser are you using?

Best,

Andrée

Paul Newcome

For the paperclip issue, Andree is probably a better one to speak to.

 

As to the formula... It isn't necessarily a specific formula that is used to link, but when you are typing a formula there is an option to "reference another sheet" in the formula help box.

Andy.Mott

Hi,

clicking on the paperclip loads up another window which allows me to select another sheet from within Smartsheet. I then click on the sheet I require which loads up the data in the Window. I then click on the cell I want to link. Once I click on create link, it takes me back to my sheet, but doesn't show the data or the little blue arrow to show the link has been created. I even check to see if I had accidently left the cell writing as white!

I am using Internet Explorer for Smartsheet

Andrée Starå

That's weird!

Have you tried to do it thru Paste Special instead? If you can, I would recommend trying it in another browser.

If you haven’t already, I would also recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

Best,

Andrée

Andy.Mott

Hi,

Ive tried this on Google Chrome and it seems to have worked. Ive logged back in to Smartsheet on Internet Explorer and can see the Links are still there. So maybe is a browser issue with this. 

Andrée Starå

We're getting closer to a solution!

Do you use any add-ons/plugins in Internet Explorer?

Best,

Andrée

Shawn Connelly

I just experienced this same issue using Internet Explorer 11. It worked for two links, and then stopped working. When I tried it in Chrome, it started working again. Now I will have to make sure my entire team has access to Chrome, as IE is the default browser for the firm. Please fix!

Mica

Hi there,

I couldn't find the post that had the same issue with linking cells-

I will post it here, maybe this will help someone.

I had an issue with only 1 column while linking cells. The rest of the columns were linked and working fine except for 1. this was happening cause the column properties were set as 'dependencies enabled'. I removed that option and the links worked with no issues.

I hope this helps.

Mica