Exceeding Cell Reference of 25M
Hello Community friends!
I and a customer of mine have both had complex sheets suddenly start throwing this error message:
Some cross-sheet formulas can't be updated, because this sheet has more cells referenced from other sheets than the maximum allowed (100,000).
I contacted Smartsheet support about my sheet, and they stated that I am actually exceeding the 25M cell reference limit. Now, the difference between last week, when I didn't see this error, and yesterday, when the error popped up, is maybe two additional rows. My sheet contained about 20 columns with index/match formulas, and I realized that I could delete 5 of them that were not necessary. I figured that if I reduced the number of cell references per row by 25% on a sheet with 150 rows, that would easily take us back under the 25M limit.
Unfortunately not - I am still getting the error.
I am in touch with Smartsheet Support about this, but I wanted to reach out to others in the Community to see if you have suddenly started experiencing this in the past two weeks. Our customer is also working with Support, because their sheet is similar to mine - their number of rows stays fairly consistent and the sheet was fine before last week.
Thanks for any insight!