Why does my Metrics constantly stop calculating correctly?
I've been making a "Metrics" sheet for some time now, and in the beginning everything was calculating fine. But it seems to be when I add more "data tables" if you will, or more metrics, some tables stop calculating correctly. Here is what my sheet looks like for a better understanding
So, the first few-ish sections will be fine (Overdue Project Site Visits),(PM Overdue Installation Dates), and (Superintendents' Target Project Site Visits). I put in the correct COUNT formulas, it computes the right numbers. Then, as I make more, or go down the line and enter those required COUNT formulas, (Project Managers' Estimated Installation Dates), etc. The first 3-ish will break completely. They wont have an error or anything, they just stop computing correctly altogether. Then, to fix this, I'll retype the exact same formula, but from scratch, and then It will compute fine. But, if I go back to the (Project Managers' Estimated Installation Dates) table, that is now broken.
It feels like I have reached a limit on the number of COUNT formulas I can have running simultaneously on the same sheet, but I can't confirm this because there is no error message. I hope this makes sense. I'm more than happy to clarify if need be in order to fix this annoying problem.
Another picture to give more visibility. The top table is expanded and is now broken, because I just fixed the bottom table which is also expanded. The bottom is "fixed" because I just re-entered the same formula, but from scratch. Is there a limit I am reaching? Maybe formatting issue of my metrics sheet? Any feedback is appreciated.
Help Article Resources
Check out the Formula Handbook template!