Welcome!

Cross-Sheet Reference Error

Hello,

I am receiving an error window stating that the sheet has reached the max number of different cross-sheet references. Would someone be able to provide more insight on max level of cross-sheet references?

Thank you

Find more posts tagged with

Support

Comments

Chris McKay

Hi OBR,

Previously discussed here: https://community.smartsheet.com/discussion/maximum-number-cross-sheet-references-sheet

Daniel Stein

There are 2 relevant limits for cross-sheet formulas:

A total of 25,000 cells can be referenced in from other sheets.
A total of 100 distinct cross-sheet references can be created on a sheet.

Additional information about cross-sheet formulas is in our support article.

Chris McKay

Daniel, I have to say I'm not very impressed with the limits or the fact that the support article has still not been updated to highlight the 100 cross-sheet reference limitation.

It couldn't take more than 5 minutes for someone to amend the article to include:

Please note: A maximum of 100 cross-sheet references can be created for each sheet. Duplicate references using the same range elsewhere on the sheet will not count towards this limitation. If you require more cross-heat references, please consider using cell-linking as an alternative.

Chris McKay

Almost 2 weeks later and still no update to the support article. Someone has to be accountable for these articles being kept up to date. Really poor form guys.

J. Craig Williams

I have forwarded this post to someone that I believe cares (and works at Smartsheet)

Craig

Daniel Stein

Thanks Chris for checking in. I thought I responded to your earlier post, but it looks like it may not have posted for some reason -- apologies.

The help article is now updated. For context: our support team tracks and reviews content update requests at regular intervals and updates content in a way that ensures consistency across all our articles. This is why updates typically don't occur right away. I agree that 2 weeks is a bit long.

Thanks for your patience, and please keep the feedback coming.

Chris McKay

Thanks Craig

CRL18

I have created a approval workflow for two forms. Some information needs to be pre-populated from form 1 into form 2. Can I write a code in the url link in form 2 to have the information appear on the form?

Andrée Starå

Hi,

Not sure I follow!

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic View Editing Role
Hi all, I want to utilize the Smartsheet Dynamic View. Considering the "editor access" type in smart sheet I wonder if the users are aimed to edit the view, should have the editor role? If I am not shared the file with them, will they stay as a Smartsheet user with viewer settings but are able to view the file? Thank you!
Cannot create new Chart from a report
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Limiting Access to Folder and it's assets
I shared access to a user to a specific folder under workspace A (folder is 2025-09-Service Factory). However, I can see that he's shown to have access to all the other child folders under 02-ACTIVE Initiatives. Why is that when I only shared out one folder? Is there a way to only share access to users to ONLY specific…