Index Match References Disappearing
I am experiencing glitchiness around programmed index match references disappearing. The sheets I have linked will function fine for a period of time and then we will notice the data begins to simply not populate in the receiving sheet. When I look at the index match reference, its gone and I have to remap it. Our formula is correct, , but when I click on the formula to check the sheet reference, it either gives me a blank slate asking me what sheet and columm I am trying to reference (even though it should already remember this information). or it has a different sheet selected and I need to corect it. The formula columns are locked to the users, and we are all on chrome browsers. This is happening at an exhausting rate and I can't figure it out. Any input is appreciated.
Help Article Resources
Check out the Formula Handbook template!