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

Capturing Cost Savings by the month
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
Automation to send Reminder @ 60d, 30d, etc
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
How do I share a report document to an external client without having to give full access to the doc
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…