Too many Formula Cell references

Susan Vieira

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.

Leibel S

@Susan Vieira

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...

Susan Vieira

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?

Leibel S

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

Susan Vieira

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!