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.
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!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
This might be a silly question but I'm stuck...a little rusty! I am trying to do a count formula for a dashboard that has a summary of how many sites are activated using this column whenever it's starred. The formula will be on a separate sheet used for dashboard metrics. Is it =COUNTIF(Sheet reference), HAS(@cell)) I know…
Hi, I am wanting to display multiple vlookup results from a separate sheet into 1 cell. Example: Cabling Allocation Sheet, where we input an allocation to a text name "ECC" which can be multiple cables in the same run. Requirements Sheet - Need the output to be "115, 116, 117" (I have manually written them in at the…
I am reaching out to seek your assistance regarding an issue I'm encountering while calculating the number of surveys completed on each day of the week (Monday-Sunday). Despite various attempts to identify the correct day of the week using functions like DAY, WEEKDAY, and DATEONLY, I am consistently facing discrepancies…
©2024. All Rights Reserved Smartsheet Inc.