Cross-sheet reference cells limited

Sherman

hi all

Is anyone have the same issue like this, one sheet reference other sheets and more than 100,000 cells will cause some problem?

Thanks,

Sherman

Andrée Starå

Hi @Sherman

Yes, if you have more than 100,000 cells referenced from other sheets, you’ll see the message.

What cross-sheet references are you using in the sheet? VLOOKUP or INDEX/MATCH?

More info:

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!