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

Set Up Links for Board View
In my grid view, I added a column that takes a hyperlink but when I mosey on over to Board View, only some of the columns appear as attributes displayed on the card. Can I make the hyperlink appear here?
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…
Automatic Unalignment of Dashboard Widgets
Is anyone experiencing their dashboard widgets automatically being unaligned or they have moved a bit from your last save? I am the type where I like things clean and aligned. Some may say it's OCD. In Dashboard, this can mean the edges of my widget line up, each section is centered or same purposed widgets are the same…