nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Cross-Sheet Reference Error

OBR

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

Automation circling and unsure how
I have automations circling between each other and retriggering. I cannot seem to find how it is taking place. Currently I have approval automations that are separated out in numeric order. Instead of going from one approval to the next, my trigger is a Place in Approval Process Column that changes to the next approval…
Autocomplete does not show words starting with the letters being typed
Hello, It appears that the autocomplete has changed for some of my dropdown list columns. It shows all of the words that contain the letters being typed instead of just the words that begin with the letters being typed. For example, I used to be able to type "US" in my "Country" column and the autocomplete would show…
Sending mails out of office through automation not working
Hi, I am trying to send mails to my vendors through my smartsheet. I have an automation workflow for this. When the value in column "Send Mail" is set to yes, it shall send a mail to people who are added in Supplier Contacts 1 column which is a contact list type. I get a notification saying "Not all recipients will receive…