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

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