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

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭✭

    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!

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!