Cross-Reference sheet limit

Jonathan Valente

Hi,

I am having issues adding cross-references to my sheet. I have a total of 51 cross refence links on my sheet yet I am unable to add anymore. I have read that the max number per sheet is 100.

I have scanned through each reference and have found that after crossref47 it jumps to crossref96 in the next cell. I have tried to manually change the cross-ref name to the next in the series but smartsheet tells me that that number is already in use on the sheet. I have looked through the whole sheet no cells have crossref48-95.

How can I fix this error? I have tried to create a new sheet and start again but the exact same happens after crossref47. Is there a way I can filter through cross refences on the sheet to see where they are being used?

Thank you for your help.

Andrée Starå

Hi @Jonathan Valente

I hope you're well and safe!

What is the error message you receive?

Have you looked in the Sheet Reference Manager?

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets#ref

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Is there another sheet containing cross sheet references to that same reference sheet?