Too many Cell References Error
So i am making a sheet to keep track of different devices i mangage. While doing this i ended up with a lot of duplicate columns (Ex: Description column and another column named [DESCRIPTION] with the formula "=Description@row")
Since getting the too many cell references error i deleted about half of the columns i had and all the duplicate columns i had but it is still giving me this error.
Also my reference manager is saying there are 0 cell references. What can i do to fix this?
Answers
-
Can you take a picture of your reference manager?
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
-
Ok, what is happening here is a different error than I originally thought. What is happening is your reference area in your formula is too large. So if you are using a VLOOKUP for example and it is going across 100 columns with thousands of rows of data, sure your sheet references are only 3, but the total amount of cells references is too many.
This is why INDEX/COLLECT is better than VLOOKUP any day. What is the formula you are using that is giving this error?
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!