Too many Formula Cell references
Hello,
I received this warning in my Smartsheet and am not sure why? I have about 36 columns and ~2400 rows, 11 columns are formula columns. Do I have too many formulas? I have 6 cross sheet references. Appreciate any help.
Answers

This is a bit hard to write, but I will do my best:
The basic issue is that if in order to evaluate the value of the cell Smartsheet needs to evaluate 25,000,000 cells it wont work.
So for example if you have a SUMIFS function that references 2 columns then in your case in order to calculate the value of the cell Smartsheet needs to evaluate 2400+2400= 4800 cells.
But if these 2 columns have for example a COUNTIF function that references another 2 columns, then for your cell to calculate it would be something like 2400 * 4800 = 11,520,000
If you add another couple of variables here you can surpass 25,000,000...

Hello, thank you! I understand your SUMIFS explanation. I have SUMIFS (no COUNTIFS) and am referencing a total of 52 columns (some more than once but I assume this counts) and I only get 130 000 cells being evaluated.
Apologies, I am not sure I am understanding the second explanation of count ifs. Do you mean, if I am referencing a column in my Sumifs that has a Countifs, then the cells references grows exponentially?

Correct, for every reference those 52 columns have it grows exponentially.

Ah, I see my problem now. I have a SumIFS that references 2 columns, each with their own SUMIFS...without doing the math, I am assuming that is it. Thank you!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!